refresh subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I populate a bound subform by programmatically changing the underlying query
statement, passing the ClientID to the query definition. This is so that the
query returns a single record rather than thousands and hopefully speeds up
the form.

Problem is, I can't seem to get the subform to refresh once the query
statement has been changed. If I close the main form and re-open, the subform
is properly populated. So everything appears to be functional if I could just
get the subform to refresh. I've tried "requery" and "refresh". Any other
ideas?

Thanks
 
What is exactly causing the change of the querydefinition?
A textbox on the form which changes it in vba?
Or the change of focus of a record?

Basically you should call the following

Forms("MyMainForm").MySubForm.Form.Requery
 
Back
Top