Add record with combo box

[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

 

[Guest]

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

-Dorian

 

[Guest]

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.

 

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

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]