how do you mark it as answered from within outlook express??
Bill
"Ryan" <Ryan@[EMAIL PROTECTED]
> wrote in message
news:9227112D-744C-4039-97F6-DA8FB3E939B2@[EMAIL PROTECTED]
> 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!


|