Prev: supress warnings in ACCESS 2007
Next: Only display fields if field matches criteria
From: BruceM via AccessMonster.com on 24 Feb 2010 07:16
Oops. Try DoCmd.Restore. Sorry about that. I used the syntax for Requery
and Refresh, but Restore is applied differently.

Jesse wrote:
>I placed the me.restore in the activate event and it gave me an error of
>"Application-defined or abject-defined error". After I typed the . it didnt
>show restore in the list of objects that i could use. So it doesnt work in
>the activate event. Im not sure why it works in one instance but not the
>other either. Access can be strange sometimes.
>
>>Try restoring (Me.Restore) in the Activate event of the form. Restoring in
>>the Close event of the report applies Restore to that report, not to any
>[quoted text clipped - 7 lines]
>>>>>>>>>> All
>>>>>>>>>> you're doing is presenting a message!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201002/1

From: Jesse via AccessMonster.com on 24 Feb 2010 10:19
That worked perfectly Bruce. Thank you for your help and for your time.

BruceM wrote:
>Oops. Try DoCmd.Restore. Sorry about that. I used the syntax for Requery
>and Refresh, but Restore is applied differently.
>
>>I placed the me.restore in the activate event and it gave me an error of
>>"Application-defined or abject-defined error". After I typed the . it didnt
>[quoted text clipped - 7 lines]
>>>>>>>>>>> All
>>>>>>>>>>> you're doing is presenting a message!

--
Message posted via http://www.accessmonster.com

First  |  Prev  | 
Pages: 1 2 3 4
Prev: supress warnings in ACCESS 2007
Next: Only display fields if field matches criteria