Combo Box Limit Names to one

[RobinF]

If a Name has been added to a combo box once., and I want
to use that name again for a new record, how can I set it
so the combo box does not add the name to itself again
so that the next time I go to the combo box the name is
not in twice.

Thank You

 

[Graham R Seach]

Robin,

That depends on how you're adding names to the list.

If the combo gets its data from a table, then just use a recordset or
DLookup to test for the name, and if not found, add it in the usual way.

If the combo gets its data from its own RowSource, then use Instr() to test
for the name.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia