How to make a reset button??

[Guest]

Hi all,

I have several boxes inside a form (two combos, one tex box and 2 option
groups). Now I want to have this feature in "reset" button such that if i
press it, anything written inside any box will be dissappear/any option in
option groups will dissapear too.

How to do it?

Thanks
JV

 

[Steve Schapel]

JV,

It could be that the controls on the form are bound to fields in the
form's underlying table/query? If so, it may be applicable to simply
delete the current record. If so, I would suggest a macro on the Click
event of your Reset button, with these actions:
RunCommand/SaveRecord
RunCommand/DeleteRecord
GoToRecord/New

If this is not what you want, or if these are unbound controls, you can
use a macro with a SetValue action for each of the controls, something
like this...
Action: SetValue
Item: [NameOfYourTextbox]
Expression: Null
Action: SetValue
Item: [NameOfYourOptionGroup]
Expression: 0