The data should display automatically once the filter is set.
Requery loads all records: really only necessary if you (or other users)
have altered the data elsewhere.
Refresh is less dramatic, but still should not be needed.
Recalc causes Access to figure out the values for the calculated controls
again. Calculated controls are those that have an expression in their
Control Source (i.e. the Contorl Source starts with an equals sign).
None of these are needed to display the results of a filter. If you have set
the form's filter like this:
Me.Filter = x
then don't forget to do this as well:
Me.FilterOn = True
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
Reply to the newsgroup. (Email address has spurious "_SpamTrap")
"Warrio" <warriotiscali.ch> wrote in message
> After that I have changed the filter of a form, how I get immediately> the new data displayed?
> (The textboxs are all linked to the same record source as the form.)
> I have tried :
> none of these works..