Competent Performer
Windows 7 64bit 
Access 2010 64bit
All,
I am just a beginning with VBScript in Access. I am sure it will be very easy for you to spot what I did wrong below. I am trying to filter "Referrals" where Payors appears in a multiple search list, as well as DeclineReasons in a multiple search list PLUS the PCriterias, which is a bunch of other fields. Ty for your help in advance.
Task = "select * from Referrals where ([Payor] in (" & StrSearch & ") & [DeclineReasons] in (" & StrSearch2 & "))" & " AND " & PCriteria
Sincerely,
Perry
VIP
Windows 10 Access 2010 32bit
Use AND in place of the & character in front of [DeclineReasons].
Task = "SELECT * FROM Referrals WHERE ([Payor] IN (" & StrSearch & ") AND [DeclineReasons] IN (" & StrSearch2 & ")) AND " & PCriteria
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Me.Dirty=True
Windows 7 32bit Access 2010 32bit
Try adding a debug.Print Task - to see what the sql resolves to. Should help you to see whats wrong.
If this helped, please click the star * at the bottom left and add to my reputation- Thanks
Competent Performer
Windows 7 64bit Access 2010 64bit
June7, ty, as easy as that! and ty for the tip, Moke123 as well.
Can't figure out where I am going wrong
Syntax check: novice is missing something and can't figure it out...
Date Syntax in vba is wrong ?
Posting Permissions
Reply With Quote