Default Record When Opening Form

[ProgEval]

I have forms set up and when they open, the first record in the table shows up in the entry fields. Is there a way to get be blank or to even show a dummy record, instead of showing the data for the first record in the table?

Thanks for your help!

 

[Remou]

You can open the form at a new record, or set the recordsource to an empty table.

 

[PHV]

Set the DataEntry property of the form to True or use acFormAdd as 5th parameter of the DoCmd.OpenForm method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886