ComboBox add record/Lookup

[Bryan Boukari]

I am trying to make a combo box lookup records in a table
and if the data being entered into the box doesn't already
exist in the table, I want the box to add it.

I.E. I have a list of clients. My person should be able
to type the client's name in. If the name exists, when
the person hits enter, it brings up the other data in the
record. if the name does not exist, I want a new record,
using the typed name, to be created.

Bryan

 

[Gary Miller]

Here's some sample code to deal with this issue
http://www.mvps.org/access/forms/frm0015.htm


--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________