Access 2007 Requery Not Working
Posted on 2011-02-22
I have a form with multiple subforms on it. The original application was written in Access 2000. I requery a form that has totals on the bottom of it.
For Example: Field is Sales
In the bottom of the form in the footer is a field total that is =Sum([Sales])
I run some queries to build the subform data and then refresh the subforms as follows:
Me.cmdUpdate.Visible = False
Me.FormHeader.BackColor = -2147483633
The first time I make selections and run it, all is well. If I change the criteia and run again, all the sum fields disappear. I can sit for 10 minutes and they dont display. If I pop off Acces to another open application like Outlook and pop back, the fields display fine.
Never had the problem before "07" any thoughts are appreciated.