Create checkboxes during form open based on query

[PhilBear]

I am working on a database that tracks products. The products are divided into groups (Bath Salt, Stick Incense, Candle, etc.) and these are store in a table. The products themselves are stored in another table.

When a new scent is created, it can belong to multiple groups ... for instance, Strwberry Vanilla could be a perfume, a bath salt, a candle, stick incense.

When the form is opened, I want to read the contents of the groups table and create a check box for each entry.

I do not really want to use a list/combo box for this task ... would prefer to be able to check in a list of boxes to specify what groups to create entries for when a new product is entered.

Thanks
Phil

 

[Uncle Gizmo]

I'm pretty sure that for some reason you cannot create controls on an access form once it's opened. But you can hide controls on the form, and then make them visible when you need them. Also you can move them around, with code.