Updating a lookup

[AceBK]

I am using Access 2010 and I have a number of different tables. One of the tables is a list of parts. I also have a form called order form. In my order form I have a lookup box to lookup different parts. I use a form of the parts list to add new parts, however, when I add a new part to the list, it does not show up in my lookup field on my order form. How do I update the lookup. I am using a split database. So front end and backend.

Please help.
AceBK

 

[RuralGuy]

Are you using the NotInList event of the ComboBox to invoke the "add new part" form?

 

[DavidAtWork]

It may just be a refresh issue. After the event of adding a new parts record, you may need to refresh the order form or requery the combo lookup (assuming the combo is running off a query)
David

 

[vbaInet]

Are you using the NotInList event of the ComboBox to invoke the "add new part" form?

... or are you using the List Items Edit Form property?

 

[AceBK]

It seems to be working, I think what happened was the description of the new item was very similar to another item, I didn't notice it on the list. Thank you all for your help

 

[RuralGuy]

Thanks for posting back.