CLEAR MORE THAN ONE UNBOUD TEXT BOX BY CLICKING AN ACTION BUTTON

[dewaldv4]

Hi there,

I have a form which I use for working out the difference between a sales price and cost price of items - the answer is then displayed in the 3rd text box.

I would like to click on a button that will clear the contents of the first two text boxes simultaneously.
I am using ACCESS 2010.

Please forward me an answer to (e-mail address removed)
If it would help. I can email a photo of the form to whomever is able to help me.

Thank you
Dewald

 

[John W. Vinson]

Hi there,

I have a form which I use for working out the difference between a sales price and cost price of items - the answer is then displayed in the 3rd text box.

I would like to click on a button that will clear the contents of the first two text boxes simultaneously.
I am using ACCESS 2010.

Create a button using the Button Wizard. Create a Macro in the button's On
Click event with two lines, using SetValue to set the value of each text box
to Null.

Please forward me an answer to (e-mail address removed)
If it would help. I can email a photo of the form to whomever is able to help me.

This is a volunteer staffed newsgroup. Microsoft stopped supporting (or even
hosting) it years ago. See my .sig for other self-support options.

I am (like most of the few people who still use this newsgroup) a self
employed consultant. As such I can only provide private email support to
paying customers. It'd be a LOT cheaper to use one of the forums below.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com