Requery Subform

  • Thread starter Thread starter Patrick Huffer
  • Start date Start date
P

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.
 
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.
 
Back
Top