Access MS Access Forms

A

accessn00b

Joined
Dec 7, 2012
Messages
10
Reaction score
0
Hi Again,

This is probably something really simple that I am missing but I've created a simple form in my access database to add/update records. The only way I seem able to set it up however is that it pre-populates with the first record on the table when I open it and I have to create a button to add a new entry.

It it possible to make it open ready for a new entry?(i.e. Blank)
 
alow

alow

Joined
Mar 20, 2012
Messages
764
Reaction score
4
It's been a while since I set this up, but I believe you want to open the form in Design View. Then Press Alt+Enter to get into properties. Click on the square in the upper left to select the Form itself (Above the left ruler and the left of the top ruler). Then go to the Data Tab of the properties and change Data Entry to Yes, or True (I forget which). This should allow the form to open up on a new record by default for data entry. If that doesn't work, I'll need a bit more time to actually step through the process again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MS access forms list box problems 1
Access Access 2003 Carriage Return Insertion 0
Access Automatically Send a notification email once a record is added 0
Access MS Access 2013 to MS Access 2010 Conversion Issues 0
Access MS Access Training Database 0
Access Validation rule in MS access 2010 1
Access Sum function in an Access Form 1
Access MS Access Data Entry Issue -> Please help! 0

Top