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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter By subform?.....

Status
Not open for further replies.
Ryon

Ryon

Technical User
Nov 1, 2002
64
US
Hello,
Please tell me this is possible. I have a mainform named "FRMCLIENTS", With a subform called "FRMLABS". The subform is a Tabular form with multiple entries per client.
The subform has a field "LabNum" which is link with one to many relationship with the client "KEY"(one side).

What I'm trying to do is Filter the mainform base on the "LABNUM" on the subform. EX: Give me only the clients who are using lab # 701.

Thanks ahead of time,
Ryan
 
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
949
Kennelbloke
Kennelbloke
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
3K
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
715
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Subform not updating 1
Replies
12
Views
928
TrekBiker
TrekBiker
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
2K
JanaLNelson
JanaLNelson

Part and Inventory Search

Sponsor

Back
Top