Form to update primary table and combo box table

**sarsmelt** · 10-08-2014, 11:44 AM

I have a table, Product_Code, that includes multiple combo boxes from different tables (ie: Machines, Products, Screens).
I have a form to enter new product codes that links directly to the Product_Code table but I need it to also add new choices to the Machines, Products, Screens combo boxes for the future.

How can I do this?

**June7** · 10-08-2014, 12:52 PM

Already marked solved - is it?

If you want to do this 'on the fly' during data entry, use code in the combobox NotInList event to add record to the lookup table and requery the combobox. The combobox LimitToList property must also be set to Yes.

**sarsmelt** · 10-10-2014, 05:33 AM

Originally Posted by June7

Already marked solved - is it?

If you want to do this 'on the fly' during data entry, use code in the combobox NotInList event to add record to the lookup table and requery the combobox. The combobox LimitToList property must also be set to Yes.

yeah I figured it out and didn't know how to delete it

Form to update primary table and combo box table

Thread Tools

Form to update primary table and combo box table

Similar Threads

Use Combo Box in (Sub) Form to Update Table Field and Create new List box.

Update Record in Related Table Without Entering Primary Key on Form

built form on top of table use combo box to update value on form. dont update table

Using 'aliases' table as a lookup table to find the primary key 4 'main name' table

Combo box to update table in a form

Posting Permissions