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!

ServerFilter

Status
Not open for further replies.
198311

198311

IS-IT--Management
Mar 2, 2006
26
0
0
DE
hello,

Is Possible thah I can Use double Filter in ADP Project ??
I have my code , but it doesn't work :(

Me.ServerFilter = "[name] = '" & name_ & "'"

Me.ServerFilter = Me.ServerFilter & " AND " & "[country] = '" & country_ & "'"



Me.FilterOn = True

Me.Requery


???
 
Sort by date Sort by votes
Try resolving into a variable first.

Dim var1 as string

Var1 = "[name] = '" & name_ & "'" & " AND " & "[country] = '" & country_ & "'"


Me.ServerFilter = Var1
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

batteam
  • Locked
  • Question
Question on ServerFilter property 1
Replies
1
Views
26
cmmrfrds
cmmrfrds
sophieK
  • Locked
  • Question
Problem with serverFilter
Replies
5
Views
35
dwight1
dwight1
GammelNok
  • Locked
  • Question
ServerFilter
Replies
1
Views
30
cmmrfrds
cmmrfrds
Fubear
  • Locked
  • Question
ServerFilter Automatically Saving 2
Replies
3
Views
41
Nowell
Nowell
bugs75
  • Locked
  • Question
BuildCriteria and ServerFilters
Replies
0
Views
23
bugs75
bugs75

Part and Inventory Search

Sponsor

Back
Top