Gloria has attended:
Access Intermediate course
Access Advanced course
Open new record on opening access
When opening access how do you get access to automatically display a new record ready for entry, normally when it opens it goes straight to the first record
RE: open new record on opening access
Hi Gloria,
Pleased to receive your post, hope this helps...
Create your form as per normal, Format and arrange the Fields, Labels, Headings etc. etc.
If necessary you could populate it now with any data that you have currently. When the form is created and populated to your satisfaction, save it and name it something like "View Records".
In Datasheet view, make a copy of the Form (File, Copy; File Paste) name it something like "Add Records".
Open Add Records in Design view and activate the Form Properties list, Under the Data Tab, choose Data Entry and from the Drop Down arrow slect "Yes". Close the Properties pane and save the Form. Close the Form.
From the Database window select Tools, Startup, in the Display Form/Page option click the Drop Down and select your new form "Add Records", click OK.
The next time you open the Database, The "Add Records" form will open prompting you to add new records. If you wish to view all records, you will need to change to the "View Records" Form. (Perhaps place a button on the page to do this).
Hope that helped.
