Refresh Causing Database to Lockup

[Reginald]

I am having a weird problem using the refresh command if I have SR1a loaded.
the code I use to refresh my form is;
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
after i have refreshed the database works fine but it does not allow me to
close the database. Sometimes a error message comes up "Run-Time error
'2486' You Can't carry out this action at the present time
the only way I can get out of the database is to go into task manager and
ending task on MSAccess.
It is weird though I do not have this problem until I update to SR1A, and
then I figured well maybe if I put SP3 for Office it will fix the problem,
but I am still having the same problem. Any help would be greatly
appreciated.
Thanks,


Reg

 

[Reginald]

Still waiting on help if anyone can help, Thanks again

 

[Hugh O'Neill]

Still waiting on help if anyone can help, Thanks again

What version of Access are you using? From your DoCmd line it looks
like A97 but the latest SR is 2a not 1a and 2b for jet. As far as I
know, there's no SR3 for that version of Office.

In any case the better refresh command is:

Me.Refresh

or

Me.Requery

depending on what you are wanting to do. The acMenuVer stuff is
version-specific.

hth

Hugh