Help with startup

[Tari]

Hey,

I'm not very good with Access, so I need your help please.



I have the startup defined to open one of my forms when you open the DB. When it opens it automatically displays the first record. I need it to show the last record though, so an empty one. How can I get that done?

Same with a macro I'm using:

Macro Name: AddCustomer : On Click
Action: Open Form
Requery

Form Name: Add or Delete Customer
View: Form
Filter Name: <blank>
Where Condition: <blank>
Data Mode: Add
Windows Mode: Dialog

I need this macro to display a blank record as well

Thanks already for your time!

Tari

[ajetrumpet]

a BLANK record or a NEW record? if NEW, change the "dataentry" property. that's it.

[Tari]

Thanks for your quick answer Adam.

Yes new record, sorry poor choice of words

And unfortuantely I don't quite understand your answer. I please need exactly which entry to change and what to change it into. Sorry, as I said I'm not good at this.

Thanks!

[ajetrumpet]

know where the property sheet is for forms? It's in the toolbar in 03. Open the form in design view and click the icon on the toolbar at the top that looks like part of a hand holding an 8x10 piece of paper in it's fingertips.

Or...right click on any control and choose "properties". Then in the dropdown menu at the top of the property window, look for the word "form".

[websterh]

I believe another option is to create an Event Procedure with the On Load event.

• select, in the Design view, the Form's window (top-left should be a small black box) and then click-and-display the properties (should be a pop-up view on the right-side of screen) and select the tab called 'Event'.

• then with the 'On Load' option select from the drop down [Event procedure] - when done click into it and paste the following code to this event/procedure:

DoCmd.RunCommand acCmdRecordsGoToNew

this opens the form to a new record (empty/blank fields); find records can still be done if you want to insert a find record button or using the built in option in the MS Access menu area.

this code has worked for me in both Access 03 and 07.

[Tari]

know where the property sheet is for forms? It's in the toolbar in 03. Open the form in design view and click the icon on the toolbar at the top that looks like part of a hand holding an 8x10 piece of paper in it's fingertips.

Or...right click on any control and choose "properties". Then in the dropdown menu at the top of the property window, look for the word "form".

That worked, awesome! Solves another problem of mine too, as users tend to not pay attention and overwrite older records Thank you!