Cut Command In Form

[Kelvin]

I would like to use a Command Button located in a form
and when I click it, it will clear imformation in two Text boxes with out deleting the table.
The text boxes are located in the same form.

Please Help

regards Kelvin [sig][/sig]

 

[PaulF]

Without deleting the table????

if no data was previously in the textbox you can use any of the following

me.textbox1 = vbNullString
me.textbox2 = vbNullString

me.textbox1 = Null
me.textbox2 = Null

me.textbox1 = ""
me.textbox2 = ""

however if you are trying to recover original information that you typed over, use:

me.textbox1 = me.textbox1.oldvalue
me.textbox2 = me.textbox2.oldvalue

PaulF [sig][/sig]