Combo Box Limit Names to one

  • Thread starter Thread starter RobinF
  • Start date Start date
R

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