resetting controls on form

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

Guest

Hi all,
I currently have a form with dozens of controls on it which are hidden when the form opens. Depending on the values entered in the only visible control, other controls are made visible.
Is there a way to reset the form to its original state once a new record is created? By this I mean, no matter what controls are visible now, hide them all again just like they were when the form first opened.
Thanks in advance
Dave
 
Try using the OnCurrent Event or AfterInsert and setting your hidden
fields to false.
me.fieldname.visible = false.

From what I understand the OnCurrent event is used when a form containing
data is first opened and when you move to a different record. The
AfterInsert occurs after the new record is saved.

--
G Vaught


Dave said:
Hi all,
I currently have a form with dozens of controls on it which are hidden
Click to expand...
when the form opens. Depending on the values entered in the only visible
control, other controls are made visible.
Is there a way to reset the form to its original state once a new record
Click to expand...
is created? By this I mean, no matter what controls are visible now, hide
them all again just like they were when the form first opened.
 
Back
Top