Access a table from a form and then lookup the new record

[JoanneZM]

When I can't find an item in my lookup table I have a buttom that brings up a
data entry form for that table. When I add the record and close the table,
the original data entry form is still on my screen. If I try to look up the
item that I just added to the table, it does not appear. What am I missing.
Should I create a query to requery the table?

 

[Jeff Boyce]

Joanne

Check Access HELP for "NotInList" -- there are code examples that include
the use of a "return" constant to tell Access to requery. Note that this
applies to the use of a combo box on a form. It isn't clear from your
description if this is the environment in which you are working. If it
isn't, consider that tables are great for storing data, but forms are great
for displaying it (and entering).