Reset Button..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to clear all textboxes, comboboxes and checkboxes on the
form with a reset button ? I know we can do it in web programing and wonder
if we can do the same thing in Access??
 
If the form is bound to a table, you can reset it with:
Me.Undo

If you want it to move to the new record as well:
RunCommand acCmdRecordsGotoNew
 
Appache said:
Actually my form is not bounded to any table..
Click to expand...

Well, for an unbound form you could loop thrpugh all controls and set them to
null, but it's usually just as fast to close and reopen the form from code.
Usually that's so fast that the user doesn't see anything but the fields
blanking out.

DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "FormName"
 
Thank you..
--
Thanks


Rick Brandt said:
Well, for an unbound form you could loop thrpugh all controls and set them to
null, but it's usually just as fast to close and reopen the form from code.
Usually that's so fast that the user doesn't see anything but the fields
blanking out.

DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "FormName"
Click to expand...
 
Back
Top