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

J

jalewis999

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.
 
M

Martin

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)
 
J

jalewis999

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 [email protected]

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...
 
Top