Two ways to do this. First way is to set the On Open event of the form.
Private Sub Form_Open()
DoCmd.GoToRecord , , acNewRec
End Sub
Second way is to use the click event of whatever opens the form. Say you
have a button on a form called OpenSalesFunctions. The code would look
like
this.
Private Sub OpenSalesFunctions_Click()
DoCmd.OpenForm "YourFormName", , , , acFormAdd
End Sub
--
Please remember to mark this post as answered if this solves your problem.
"advanced dabbler" wrote:
> I have a sales database that I'm building to keep track of sales
functions,
> contacts, etc. I have one form that has multiple drop-downs based on
data I
> supplied and not a table/query etc. It also has yes/no check boxes. I
need
> everything to reset when the form is opened and when a new record is
added so
> that nobody accidentally uses information input by the previous user.
I
> don't know if that makes sense, but, if someone can figure it
out.....please
> let me know.
>
> Thanks!
|
