Form Save Prompt

[Guest]

I have an add to events form that loads a table 6 fields; I use combo boxes
to for four fields and two field that need direct input from user. When the
form loads now, fields populate with input from the table. I like all fields
to be blank on load and the user to click new record button and be prompted
to save before adding another record or closing the form. I do not want user
to edit on this form, I have an edit form that is launches when a report is
created. Can this be done?

Thanks

 

[Guest]

Hi,

Design the Form and enter the following on the Forms OnLoad Event

DoCmd.GoToRecord , , acNewRec

Each time your users opens a Form they will immediately go to a new record

HTH
Mark

 

[Guest]

Thanks mark that will solve most of what I wanted.