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

Opening Microsoft Access without seeing result of old query on form

P: 1
Hi Everyone,
Please, I am currently working on an Access Project and any assistance from this forum would be appreciated.
I developed some forms in MS-Access 2000 and I am currently using them to update the database.
However, I noticed that whenever I reopen the database/form, the first form that is displayed usually contain the result of the last query or record viewed. Please, how can I open an access form and have all the fields as empty. Thank you for any assistance
Dec 25 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,072
Access will by default show the first record from a recordset a form is bound to. To get an "empty" form you can set the form's "Data entry" property (under the Data tab of the properties window) to "Yes".
The effect will be that the form can only be used for adding data and I'm not sure that's what you want.
Personally I use a set of forms, one with all rows for selection and some action buttons to manipulate the data.
Check my sample database at:

Dec 25 '07 #2

Expert 2.5K+
P: 3,532
Like Nico, I'm not exactly sure what you're trying to do here, but using

Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Load()
  2.   DoCmd.GoToRecord , , acNewRec
  3. End Sub
in a form's code will give you the advantage of having all fields come up blank (unless you have Default Values set for any fields) without the disadvantage of having the form only being good for entering new records.

Welcome to TheScripts!

Linq ;0)>
Dec 25 '07 #3

Post your reply

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