Adding to a lookup table from form

[AlliCrader]

Name: addtolookup.PNG  Views: 13  Size: 10.6 KB  ID: 29799" class="thumbnail" style="float:CONFIG" />

What I am trying to do is create a box that will pop up and allow you to enter a new PART ID, Description, Price & Suppler into the lookup table. The subform on here is created from a query that uses the lookup table which is Parts and the order details table for QTY. How would I code in something so that if the PART ID does not exist in the Parts table, I can add it with the above mentioned fields?

[Bulzie]

Few ways to do it but maybe try in the properties on the combo box, make Limit to List "No", List Items Edit Form (Select the popup form used to add/edit the list values).

You could also do this manually. Sometimes I put a small button after the combobox with an astrick or EDIT in small letters or do this in doubleClick event to open the popup form to edit the list, once they enter values and close that form(model mode), I requery the combobox so the new value is available, now they select the new value from list. But that first option might work just as well also.

[aytee111]

Or set the Limit To List to Yes and use the NotInList event to run a query to add a new record to the lookup table.

[aytee111]

The PartID combobox should show the description, not the ID. The user should not be able to change the description or the PartID, only add a new one.

[AlliCrader]

I cannot get this to work.

[Bulzie]

What way are you trying to do it and what does not work, give more details and error messages.

[June7]

Bing: combobox NotInList event
Review https://msdn.microsoft.com/en-us/vba...t-event-access