open form to a blank record

[krberube]

I have a form that is used to both Enter & Edit records. There is a "search" button to aid in finding records.
I have been asked to have the form open to a blank record instead of the first record in the table.
Is there a way to do this without setting the "DataEntry" property to true, as this basiclly disables the "search" button.

Thanks

 

[KSimm]

Have you tried an On Open event on your form that incorporates an acAddNew?

I have a search function on a form that clears the form when the search button is clicked and incorporates this statement:

DoCmd.GoToRecord , , acNewRec

Following that, I set the focus to the field that I want.

 

[krberube]

Works Like a CHAMP!
Thanks!