Combo box

[Guest]

I have a combo box in form A that is lookup the value in a table.
But the value in the table can only be use one time.
Is there a way to exclude all the selected value from showing up in the
combo box?

Thanks

 

[grep]

I guess I would try to put some sort of marker field in my table. Like:

Field: Chosen
Type: Yes/No
Default Value: No

Then, if someone selects a particular record, write VBA code which also
sets the value of Chosen for that record to Yes. Finally, set your
lookup to only select records where Chosen = No.

grep

 

[Guest]

This is what I was think but don't know how yet to write the VBA code.
Thanks