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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jalewis999 - 24 Apr 2006 06:52 GMT

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.

Reply to this Message

Martin - 24 Apr 2006 10:29 GMT

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)

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

Reply to this Message

jalewis999 - 24 Apr 2006 12:13 GMT

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 jalewis999.@hotmail.com

> Don't know but the following may be helpful:
>
[quoted text clipped - 7 lines]
> > without closing and opening it. The form is used as a sub form. If not how
> > can the saved property values be found.

Reply to this Message