Combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top