View Single Post
  #1  
Old April 29th, 2008, 07:33 PM posted to microsoft.public.access.forms
Rockn
external usenet poster
 
Posts: 48
Default Checkbox values at run time

I am trying to set up a form that will dynamically assign values to
checkboxes that are part of an option group based on the cintents of a
table.

I have set up a test form with six checkboxes and made them all hidden. I
would now like to loop through a recordset and for each record assign a
value to these controls attributes.

visible = true
option.value = PK of the record
label.value = Name of field in record
and loop to the next.

I would think I would also have to count the number of checkboxes to set the
upper bound for the loop and make sure it is not less than the number of
records in the recordset I am looking at.

Any help would be appreciated.