Updating Selection Table?

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

Guest

I know this has probably been asked before but I was wondering how I can add
a new record to a List table when it is typed in from the Selection table? I
would like to add new City names to my City list table when it doesn't exist
as a selection from selection table. Updating a one from a many.

Is there a way to do this automatically without having to go in and edit the
list manually?
 
I know this has probably been asked before but I was wondering how I can add
a new record to a List table when it is typed in from the Selection table? I
would like to add new City names to my City list table when it doesn't exist
as a selection from selection table. Updating a one from a many.

Is there a way to do this automatically without having to go in and edit the
list manually?
Click to expand...

You can use some VBA code in the NotInList event of the combo box.
(Note that there is no such thing as a "list table" or a "selection
table" - they're just tables).

If you're using a table datasheet for data entry... don't; it doesn't
have the flexibility to do what you want. On a Form you can use the
NotInList event to update your city table, for example. Try the sample
code at

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

John W. Vinson[MVP]
 
Back
Top