Clearing a form for each new record

[advanced dabbler]

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!

 

[John W. Vinson]

On Thu, 7 Aug 2008 10:26:01 -0700, advanced dabbler <advanced

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!

What is the Form's Recordsource? If it's the table into which you're putting
data - or a query based on the table - you can simply move to the "new record"
by pressing the *> navigation button, or creating your own button to do so. It
should not be necessary to blank out any existing data, because the form
should only SHOW the existing data - and there isn't any data in the blank
"new record".

You can put code or a macro in the form's Load event to move to the new
record.

 

[Ryan]

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

 

[Bill - ESAI]

how do you mark it as answered from within outlook express??

Bill

 

[John W. Vinson]

how do you mark it as answered from within outlook express??

You can't... and I don't think Microsoft actually makes very much use of the
"answered" flag.