Talk About Network

Google





Software > Access Forms > Re: Clearing a ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 5 Topic 44657 of 46786
Post > Topic >>

Re: Clearing a form for each new record

by "Bill - ESAI" <datapacks@[EMAIL PROTECTED] > Aug 7, 2008 at 01:50 PM

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!
 




 5 Posts in Topic:
Clearing a form for each new record
=?Utf-8?B?YWR2YW5jZWQgZGF  2008-08-07 10:26:01 
Re: Clearing a form for each new record
John W. Vinson <jvinso  2008-08-07 11:38:12 
RE: Clearing a form for each new record
=?Utf-8?B?Unlhbg==?= <  2008-08-07 10:45:01 
Re: Clearing a form for each new record
"Bill - ESAI" &  2008-08-07 13:50:52 
Re: Clearing a form for each new record
John W. Vinson <jvinso  2008-08-07 14:30:58 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Fri Jan 9 14:33:24 PST 2009.