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
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