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

How to specify multiple filters

Status
Not open for further replies.
jluost1

jluost1

Programmer
Jun 8, 2001
78
US
I have a serverfileter set on for a form. I would like to put 2 conditions on "Filter" property of the form: condition1 AND condition2.

Condition1 is like: ID = forms!form1!id
condition2 is like: name = forms!form2!name

But I got an error message. It asked me to look at help file to find a way to set combination to filter property. I have never found the help file.

Any idea?
 
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
615
Swi
Swi
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
2K
combo
combo
BugZap13
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
222
mikrom
mikrom
accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
508
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top