Hi Justin,
If I understand you correctly, you want to always open the form to a new
record...is this correct? If so, there are three ways of doing this:
1.) Set the form's Data Entry property to Yes, or
2.) Use a macro with the OpenForm action. In the lower window, set the Data
Mode to Add, or
3.) Use VBA code that is the equivalent of the above macro, ie:
DoCmd.OpenForm "NameOfForm", View:=acNormal, DataMode:=acNormal
where NameOfForm is the name of the form you wish to open.
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
