Dynamic check boxes in form

[KeyserSoze]

I'm writing an application where I will have a series of checkboxes on an Access 2000 form. I can create the checkbox objects with no problems.

My question is this: can checkbox objects be painted onto a form based on information from a table? In short: I would like to dynamically create checkbox objects based on the number of records that I have in a table. This would save me from having to create the objects in designer mode.

Is this possible?

Thanks!

 

[JoeAtWork]

Assuming the field bound to the checkbox is boolean.

Create a form with a datasource that includes the checkbox field. Make the form's view Continuous or Datasheet.

Now you could either use the form as-is, or you could make it a subform on another form.

 

[TheAceMan1]

How are ya KeyserSoze . . .

Since it appears your going to have one checkbox for each line . . . what wrong with a [blue]MultiSelect Listbox?[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[devRyan]

Has anyone got an example of how to do this with checkboxes? I need to dynamically create checkboxes based on the results of a query.