Add record with combo box

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

Guest

I'm using a combo box to select records from my table. What I would like to
be able to do is if the value that is typed in does not exist have it add a
new record. The combo box is based on the primary key of the table and is in
nvarchar data type. Is there any way to do this?

Thanks,
Rob
 
So if someone just mistypes a number it automatically adds a new record? Not
a very good design!

-Dorian
 
If you have a better idea, please share it! I'm open to any and all
suggestions and look forward to constructive critisism. If you don't have a
good suggestion please don't waste my time with idle critisism.
 
If you have a better idea, please share it! I'm open to any and all
suggestions and look forward to constructive critisism. If you don't have a
good suggestion please don't waste my time with idle critisism.
Click to expand...

You can use the Combo Box's NotInList event. See

http://www.mvps.org/access/forms/frm0015.htm

The example assumes a text field but it can be very simply changed to
add a number.

John W. Vinson[MVP]
 
Back
Top