Requery Subform

[Patrick Huffer]

Hi, I'm converting my applications from Access 97 to Access 2000
(actually, 2002, but using 2000 file format). I have a number of main
forms with subforms (unbound). In Access 97 I use
subformControlName.Requery when I want to refresh the data in the
subform, and it works fine. In Access 2000 this doesn't work anymore.
I tried setting the reference to the older version of DAO that I was
using in Access 97, but no luck. Instead the fields in the subform
indicate either "#Name?" or "#Deleted" and I get multiple errors,
"Object invalid or no longer set", when I click on a field in the
subform. When I close the form and open it again, the new values
appear correctly in the fields of the subform. Any ideas on how to
requery a subform in Access 2000/2002? Thanks.

 

[PC Datasheet]

Me!NameOfSubformControl.Form.Requery

 

[Patrick Huffer]

Me!NameOfSubformControl.Form.Requery

Unfortunately, same problem. I finally discovered the one thing that
works:

NameOfSubformControl.Form.RecordSource = "Same Query Name as Before"

"Requery" doesn't seem to work under any circumstances, even for
controls on the same form. But "Refresh" does work in that situation.

 

[Guest]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting