Dynamically adding checkbox to subform

[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.

 

[Duane Hookom]

Can you change the subform to a multi-select list box?

 

[Marshall Barton]

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.

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

 

[newflyguy]

This website has moved or is no longer available. Could you please answer the original question or post a link to the new site?

 

[newflyguy]

And could you make the answer pertinent to Access 2007?