Form filter on two different fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have seen nearly identical discussions on this issue but nothing quite like
this:

I want to do a form.filter on 2 separate fields with 2 separate criteria. I
can only get one to work at a time. I would like to find all records in my
subform that have either of the 2 criteria. Is this possible?

Forms!PROJECTS.DRAWINGS_Subform.Form.Filter = "[Hyperlink] Like '*BID*'" Or
"[Drawing_Status] Like '*MISSING*'"
 
Your filter needs to be a single string, not two strings with an Or between
them:

Forms!PROJECTS.DRAWINGS_Subform.Form.Filter = "[Hyperlink] Like '*BID*' Or
[Drawing_Status] Like '*MISSING*'"
 
Douglas,
Beautiful! Thank you much, your posts are always aces.
Zadok

Douglas J. Steele said:
Your filter needs to be a single string, not two strings with an Or between
them:

Forms!PROJECTS.DRAWINGS_Subform.Form.Filter = "[Hyperlink] Like '*BID*' Or
[Drawing_Status] Like '*MISSING*'"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Zadok @ Port of Seattle said:
I have seen nearly identical discussions on this issue but nothing quite
like
this:

I want to do a form.filter on 2 separate fields with 2 separate criteria.
I
can only get one to work at a time. I would like to find all records in my
subform that have either of the 2 criteria. Is this possible?

Forms!PROJECTS.DRAWINGS_Subform.Form.Filter = "[Hyperlink] Like '*BID*'"
Or
"[Drawing_Status] Like '*MISSING*'"
Click to expand...
Click to expand...
 
Back
Top