Hi all, I am wondering if anybody has or knows if it is possible to run a active link table loop and check a check box that is set to editable. What we have is a parent child set of forms with the children viewable in a table field on the parent form. In that table field there is a check box field that I have set to editable.
What I would like to do is create a table loop that will go through and check the box in all of the child records when the Select All button is pushed. I have created a guide and AL that does a set fields to the attribute value of the check box. The only thing the AL will do is NULL the field if there is a check mark in it. I have tried using the Selection Value, the Alias Value, the ID Value for that field with no luck. I even tried using " " in my set field action hoping to emulate a press of the space bar. Just to test I added an editable character field to my set fields action and the value is entered when looping no problem. Any ideas would be appreciated. I am questioning if it is even possible to set a check box in a table field because when I click on Modify Action in my set fields it adds double quotes to any value I put in there. One workaround that I though about was to do a push field, setting the check box on the child records when clicking Select All and then refresh the table but I would prefer to just set value in the table field and then push the value with the parent is saved. Thanks, Jason ARS 7.0.1 p6 Windows 2003 SQL 2005 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
