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!

Register Log in
  • Congratulations Mike Lewis 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

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.

Similar threads

kingz2000
  • Locked
  • Question
Bound/unbound forms
Replies
2
Views
250
dhookom
dhookom
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
807
JanaLNelson
JanaLNelson
TechieJr
  • Locked
  • Question
Filtering for null or empty field
Replies
8
Views
520
dhookom
dhookom
Kim296
  • Locked
  • Question
FILTER SUBFORM USING MAIN FORM FIELDS- VBA 3
Replies
8
Views
286
Andrzejek
Andrzejek
InkyRich
  • Locked
  • Question
Basic help with Access forms
Replies
3
Views
108
InkyRich
InkyRich

Part and Inventory Search

Sponsor

Back
Top