Make form default to new record?

J

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
 
R

Rick Brandt

Joel said:
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
Click to expand...

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).
 
F

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
Click to expand...

In the Form's Load event:

DoCmd.RunCommand acCmdRecordsGoToNew
 
Top