Need to add to the lookup table from a form lookup field (Access)

D

Dogger

Hi, all...

I have several tables established to maintain lookup data for a form
(commonly used names, locations, etc). I want to be able to use the lookup
field in the form to enter new data to the table on the fly. You would think
this is easy, but I can't seem to figure it out...

Thanks!
 
D

Dogger

Thanks for your help!!

Klatuu said:
If this is a bound form then you just need to set the control source for the
combo box to the field you want to update.
Click to expand...
 
K

Klatuu

If this is a bound form then you just need to set the control source for the
combo box to the field you want to update.
 
D

Dogger

Now I really feel dumb, because that's what I'm using - but the Access help
files indicate that the combo box can pass its value to another table (not
the lookup table) or another control...

Guess I'll just have an update query run every once in a while to update the
lookup table from the table the form is feeding.

Thanks...
 
Top