Add record with combo box

R

Rob

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
 
M

mscertified

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

-Dorian
 
R

Rob

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.
 
J

John Vinson

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