reset a form's properties in access without re-loading

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

Guest

How do i reset a form and it's properties to the state of first being opened
without closing and opening it. The form is used as a sub form. If not how
can the saved property values be found.
 
Don't know but the following may be helpful:

Me.[subform name].Form.[control name].OldValue
to find the previous value for a control

DoCmd.Close , , acSaveNo
to close without saving (could then open again)
 
Thank you for your help. The reason I asked the question was because I could
not find a method of re-opening the subform as a subform without closing the
parent as well. If you can help my e-mail is (e-mail address removed)

Martin said:
Don't know but the following may be helpful:

Me.[subform name].Form.[control name].OldValue
to find the previous value for a control

DoCmd.Close , , acSaveNo
to close without saving (could then open again)

jalewis999 said:
How do i reset a form and it's properties to the state of first being opened
without closing and opening it. The form is used as a sub form. If not how
can the saved property values be found.
Click to expand...
Click to expand...
 
Back
Top