Table Relationships and Adding Data

  • Thread starter Thread starter Karl Burrows
  • Start date Start date
K

Karl Burrows

I want to create a table to populate a combo box in another main table. The
problem is if I input another value in the main table, I want it to also
populate the table used for the values in the combo box. I'm stuck. Any
help would be appreciated!
 
I want to create a table to populate a combo box in another main table. The
problem is if I input another value in the main table, I want it to also
populate the table used for the values in the combo box. I'm stuck. Any
help would be appreciated!
Click to expand...

Umm... just use the table as the Row Source for the combo box. If the
form with the combo is open while you're editing the table you may
need to requery it.

If you're using the Lookup Wizard to put a combo box in a table,
consider using a Form instead. The lookup feature causes more problems
than it solves - see http://www.mvps.org/access/lookupfields.htm for a
critique.
 
Back
Top