Help! I need my form to always open to an empty record.

[ACD]

I am currently creating a database using MS Access and I am having trouble linking the forms in the way I require. I have created the two forms and have linked them successfully. The first form is a menu which then accesses the second form which will be used to store records. The problem that I have is that each time I access the second form it always goes to the first record which has already been used. This means people have to scroll through until they find the next blank record. How do I create the link so that it always goes to an unused record .

 

[MaliciousMike]

in the form properties, put "data entry" to yes.

OR

Make the recodsource a blank source. For example, creating a query which displays no results.

I chose the latter option in one of my forms:

I have a query which displays all the data in the table i want to write to, and put my "Complete" criteria to 0, which brings up nothing.
Once the new record has been created i created a button which will change "complete" to 1, thus the query will never have any data in it.

Happy travels.

 

[ACD]

thanks

this was successful thanks for the assistence