Check Boxes in Query form

[millercj]

I need to generate a form from a query which I have done via the wizard. My problem lies in the fact that I need each to have a checkbox (not fed from the query) in the form. This check box will display for each of records but the problem right now is obviously that they all have the same name and therefore are not independent of one another. How do I change this since there is only one checkbox is the form design mode?

Thanks

 

[JBurlison]

Im having a little trouble understanding what your after here, you want a checkbox for each record in your Query? or table?

maybe a little more detail about the project will help us to better understand what your trying to accomplish here.

 

[millercj]

Neither actually; the form. I want a box aside of each record so the user can either select or deselect each record. I also need the names to be dynamic because there may be 5 or 500 check boxes needed but i need to reference their values in VBA...hopefully that helps

 

[JBurlison]

what version of access are you running?

have you tried creating a multiple items form?

 

[missinglinq]

Your explanation is rather fuzzy, but it sounds as if you're talking about having an unbound checkbox for each record. You can do this, but you cannot have a "separate" one, with a different name, for each record! And if the checkbox is unbound, the value of it on one record willl be the value of it on all records! In order to have a checkbox that remains checked or unchecked, for any given record, you'll have to have a field in the underlying table bound to the checkbox on your record.