Unbound check boxes

[Rick]

I have a table with Company Names and CompanyIDs fields. I
have another table that stores certain CompanyIDs with
VendorIDs. I want to have a form that will show a list of
Company Names and include a check box that will be checked
if the Company is in the second table. I could then check
an empty check box to add the CompanyID to the second
table.

I was going to populate a list box on current of the form,
but I can't think how to tie a check box in. If I use a
subform with an unbound checkbox, when I check it, it gets
checked for all records.

Any thoughts?

Rick

 

[Ken Snell]

You'll need a field in the form's recordsource to which you can bind the
checkbox control.