Continuous form and check box

[GibFinch]

I have a continuous form in a subform that lists all vendors for a certain product. I would like to put a check box beside each vendor so I can choose a default vendor for that product. When I do, however, it will let me choose none, one, or all of the vendors. Is there any way I can get it to choose either none or just one of the vendors for that product?
Thanks for any help,
Gib

 

[Remou]

Only if the checkbox is bound to a field in a table.

 

[KornGeek]

You could do something in the OnChange event of the checkbox to:

1) Check to see if the value has been set to true. If not, exit.
2) Open a RecordSet and set the field to false for all records except the currently selected record.
3) Update the data on the form.

Warning: This is not very practical for large data sets.

 

[GibFinch]

It is bound to a field in my table. The problem is when I have more than one vendor for a product, it will allow me to choose yes for more than one of them. I want to limit this to just one of the vendors for that part. Is it something I need to do in the table, rather than on the form?

 

[Remou]

I think KornGeek has answered this. Yes no?