Make form default to new record?

[Joel Parker]

Is there a way to make a form default to a new record, but still allow
users to go back and edit existing records?

Thanks,
- Joel

 

[Rick Brandt]

Is there a way to make a form default to a new record, but still allow
users to go back and edit existing records?

Thanks,
- Joel

Either open it in data entry mode and instruct your users that all they have
to do to see other records is ti use the menu or toolbar to remove filters
(data entry mode is just a filter matching zero records).

OR

Run this code in the Load event of your form...

DoCmd.RunCommand acCmdRecordsGoToNew

(the first choice is more efficient if there are lots of records).

 

[fredg]

Is there a way to make a form default to a new record, but still allow
users to go back and edit existing records?

Thanks,
- Joel

In the Form's Load event:

DoCmd.RunCommand acCmdRecordsGoToNew