Show Blank View on Form

[theconfusedbear]

I have created a form from a table and only the startup screen when I hit the button I want the form to display a clear entry so that I can create a new contact each time - at the moment when i hit the button it shows the first record and im in danger of changing it (im having to hit the create record button) Help!

 

[ansentry]

Open the form in design view, click ALT+Enter, when you see the properites dialog appear, select Data then go down until you see Data Entry, change the No the Yes and then exit and save the form.

Next time you open the form it will be at a new record.

 

[theconfusedbear]

Bless You! thanks

 

[ansentry]

Glad to help.

 

[suepowell]

Hi,

another thought,

What john said is right and fine if you only want to add records, and not look at previous ones.

If you want to have the previous ones visible as well, then put the following into the on load event of the form

DoCmd.GoToRecord , , acNewRec

This opens the form at a new record, but keeps the others available if you want to look back through them.

Sue

 

[ansentry]

Sue,

Your are correct in saying that you can also use DoCmd.GoToRecord , , acNewRec.

However if you only want data entry and not allow users to go back and change data in error etc then it should be set for Data Entry Yes.

The OP did say;

at the moment when i hit the button it shows the first record and im in danger of changing it (im having to hit the create record button)

So that is why I did not suggest DoCmd.GoToRecord , , acNewRec.