469,904 Members | 2,131 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,904 developers. It's quick & easy.

Opening Microsoft Access without seeing result of old query on form

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
2 1366
3,080 Expert 2GB
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
3,532 Expert 2GB
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.

Similar topics

3 posts views Thread by Mike Cocker | last post: by
8 posts views Thread by wlcna | last post: by
3 posts views Thread by Harvey | last post: by
17 posts views Thread by Pam Ammond | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.