Query to show new record entries made from a form

[sbflood]

Hello,

(I'm very new to Access so please forgive and correct me if I use the wrong terminology)

Background: I created a form for data entry only where records could be continually added until you were done and closed the form. Into that form I dropped a query that kept a running list in datasheet form of all the new records entered while the form was open, and then cleared when the form was closed (so the query was empty when the form was opened again).

My Problem: I accidentally deleted that query and can't for the life of me figure out how to make it work again. Does anyone have suggestions for how to make a query work like that?

What I need:
-Query to be empty when form is opened.
-Records added while form is open get displayed in the query after record is saved.

Thanks! Let me know if I need to provide more information.

 

[sbflood]

Finally figured it out.

In the query design I wrote the following in one Field:
Expr1: IIf(IsNull([Forms]![InspectionEntry]![IRN]),0,[Forms]![InspectionEntry]![IRN])

and in Criteria:
=[IRN]

Then created a second filed for all IRN data.

So basically the query expression returns nothing if the IRN text box on the form is blank (as it will be when the form is first opened) and then as new records are added (all new records are given the same IRN while the form is open) it will display all new records entered until the form is closed.