Reset a form back to how it was when loaded

[Simon]

Is there a a button i can click that well reload the foam back up to
how it was when i started

Instead od clsoing the form and remopeing it

Thanks REgardes

Simon

 

[Arvin Meyer MVP]

Add a button and use the following code:

Sub cmdButtonName_Click()
Me.Requery
End Sub

If you've filtered the form, you may need something like:

Sub cmdButtonName_Click()
DoCmd.RunCommand acCmdRemoveFilterSort
End Sub

 

[Jeff Boyce]

Simon

"how it was when it loaded" is ambiguous...

Do you mean "showing the same data", or "with the same labels", or "with the
same background color", or ...?

If you want to 'reset' it, what has been changed that you are resetting?

"How" depends on "what"...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/