Clearing a form for each new record

  • Thread starter Thread starter advanced dabbler
  • Start date Start date
A

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

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.
 
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
 
how do you mark it as answered from within outlook express??
Click to expand...

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