I got this from my friend.. I'm not sure if we're just doing something
wrong or if this is the workaround for more Access strangeness.
-Cedar
---------- Forwarded message ----------
In order to get a form in Access to refresh you use form.requery, at least
according to the documentation. However in my experience this does not
work. In my case I want to get the back end to do a sort on my data, so I
have changed the SQL of the pass-through query on which the form is
based. Calling requery does not change anything, but the following line in
VB does :
Me.RecordSource=Me.RecordSource
Apparently if you change the record source of the form it automatically
requeries the form, irrespective of whether the value of the RecordSource
property has actually changed...
Daniel