Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Forms Filter Action

Status
Not open for further replies.

HardingR2000

Programmer
Oct 6, 2008
40
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top