Forms Filter Action

[HardingR2000]

I have a form (FormA) in which the record source returns 1000 rows without any filter applied. I have a dialog form which I open on top of FormA that applied a filter (Forms!FormA.Filter=...), which results in 500 rows being displayed. I have not done a Forms!FormA.Requery command.

Did Access do (1) an implied requery of the record source or did it just (2) apply a filter to the existing record source?

If it did (2) then I need to do the Requery if I know the underlying data changes.

What say you?

 

[markros]

Try asking this question in forum702