Dynamically adding checkbox to subform

J

jmawebco

I have a main form with a subform in it. A user selects an item from a
combobox on the main form which triggers the subform to display records
based on that selected. This I have in the AfterUpdate event of the
combobox. I am trying to add a check box to the subform at runtime that
would allow the user to select only those records he/she wants to be
updated when he/she clickes an update button.

The database does not have a yes/no field so that option is out of the
question. Simply putting the checkbox on the subform makes it so that
when a user clicks on box they all get checked.

Any help would be greately appreciated.
 
M

Marshall Barton

jmawebco said:
I have a main form with a subform in it. A user selects an item from a
combobox on the main form which triggers the subform to display records
based on that selected. This I have in the AfterUpdate event of the
combobox. I am trying to add a check box to the subform at runtime that
would allow the user to select only those records he/she wants to be
updated when he/she clickes an update button.

The database does not have a yes/no field so that option is out of the
question. Simply putting the checkbox on the subform makes it so that
when a user clicks on box they all get checked.
Click to expand...


Take a look at Albert's Multi Select example db at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
 
Top