DoMenuItem

[Keith]

I have some calculated fields on a form which on opening displays incorrect information. If I use the Records Menu/Refresh the calculations are correct.

I have added the following code in the on load event of the form:

DoCmd.DoMenuItem(acFormBar,acRecordsMenu,acRefresh,,)

I get the following Compile Error:Expected: Expression

I am using Acces 2000

I would appreciate any guidence as to where I am going wrong.

Keith

 

[Keith]

Please ignore this thread. Its Sunday morning and I was being a bit lazy. A second read through the search items led me to the solution
Provided again by Pat Hartman - I will use the Me.[Control].Requery method

Keith