link child/master field with more then one field

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,
is the a way to reffer a subfurm to filter data on more then one field
in table
 
What exactly do you mean?

A Filter affects all fields: the filter limits what rows are returned, so if
the filter has eliminated a particular row, it doesn't show up for any
fields.

Or are you asking how to create a filter that includes more than one field?
It's the same as a Where clause in a query, but without the word Where at
the beginning:

strFilter = "Field1 = " & Me.txtField1 & " And Field2 = '" & Me.txtField2 &
"'"
Me.Filter = strFilter
 
I just noticed that the subject line of your post contained more information
about what you're looking for (I tend to read the body of the question, not
the subject line!)

You can specify a number of fields (up to 10, I think) by separating the
field names with semi-colons.

Click on the Ellipsis (...) to the right of the property. That will bring up
a dialog that may make it easier.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forms: linking child/master fields on a non-embedded subform 4
Linking One child field or another in subform to main form 4
Link Child / Master fields -- QUESTION 7
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Link Master and Child fields 3
create a form, link master and child type fields 4
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
looking for strategy for subForm filter 6

Back
Top