combobox duplicate error. Need help

  • Thread starter Thread starter Coyote
  • Start date Start date
C

Coyote

A combobox has customer names, and autoexpand set to yes

If an existing name is chosen, and the enter key hit (what a user
would normaly do) I get a "changes were not succesful because it would
create a dulicate" sort of error.

I'm going to handle the notinlist issue of course, but how can I avoid
this?

Is there a way to keep it from trying to update something that is
already there?

Thanks
 
A combobox has customer names, and autoexpand set to yes

If an existing name is chosen, and the enter key hit (what a user
would normaly do) I get a "changes were not succesful because it would
create a dulicate" sort of error.

I'm going to handle the notinlist issue of course, but how can I avoid
this?
Click to expand...

If you're using this combo box to *find* records rather than to update
the CustomerID field, then it should be unbound: set its Control
Source property to blank (nothing in it at all).
 
Back
Top