Show only appended records in form

[haydenbottoms]

I have an append query that appends records to a table, and I have a form based on that table.

Users will click a button that will run the append query and then open a form for users to fill in remaining empty cells. How can I filter the form to show only the newly appended records? This seems simple but is blowing my mind.

 

[GinaWhipp]

Well, you could have a field in your table named *JustAdded* which is set to *True*. Then based the RecordSource of the Form from a query where JustAdded = True. Once the records are updated you can either the Users *uncheck* the box or write something to check that all the required fields are filled in and set to Falso on closing.

 

[haydenbottoms]

OK I think I'm following the gist of that, but the second sentence didn't make sense to me (Then based the RecordSource of the Form from a query where JustAdded = True.). Can you clarify, please?

 

[GinaWhipp]

The Form that you open to show the newly appended records change the Record Source to included...

WHERE JustAdded = True

I was assuming, by your post, it was s eperate Form.