By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,324 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

Form opens to 1st record, not next blank record

P: 1
I created a form to enter information into an Access 2010 database to start entering some of the several thousand records into the table.

I'd like the form to open to a new record, ready to fill out. However, it currently opens to the first record entered into the table. I'm afraid the other user (my boss) may open it up and change the first record BEFORE he realizes how it functions.

How can I fix this?

BYW, I don't code very well. So, baby steps please..

Thank you.
Mar 2 '17 #1
Share this Question
Share on Google+
3 Replies


P: 64
just put button to create new blank form
Mar 3 '17 #2

PhilOfWalton
Expert 100+
P: 1,430
On the open event of the form, put the following code

Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Open(Cancel As Integer)
  2.  
  3.     DoCmd.GoToRecord , , acNewRec
  4.  
  5. End Sub
  6.  
  7.  
Phil
Mar 3 '17 #3

P: 80
Or if the user's role/form purpose is exclusively to enter new data, you can simply set the form's Data Entry property to YES.
Mar 5 '17 #4

Post your reply

Sign in to post your reply or Sign up for a free account.