How can I do this in VB?

I want to perform two filter conditions in my SQL recordset...how do I state this in one uniform statement...I am new to SQL syntax so I'm not sure how to combine the two statments into one.
Right now I just have two .filter statments, one after another in my VB code. It seems it is performing the filtering tusing only the last filter statment.


Thanks,
Maria

make one filter using the AND operator

here is the example from the help

(LastName = 'Smith' AND FirstName = 'John')

David

It does not work like this...well I have a variable called temp and an actual number to compare: the number 2. I have tried a few different combinations but they don't seem to work:

temp = rstMacroData!MacroName 'Get the name from another recordset

' None of the statements work!
rstBookmarks.Filter = "MacroName = temp And DOCT_ID = 1"
rstBookmarks.Filter = (MacroName = temp And DOCT_ID = 1)
rstBookmarks.Filter = "MacroName = " & "'" & temp & "'" AND "DOCT_ID = 2"

Do you know how to do it? It seems pretty simple but I just don't what combination of ',",(,) that works!

Thanks again!
Maria

Try this one:

rstBookmarks.Filter="MacroName=""" & temp & """ AND DOCT_ID=1"


Lucian Preda
[email protected]

Thanks for the help. Just a little more tweaking and this did the job:

 rstBookmarks.Filter = "MacroName= " & "'" & temp & "'" & " AND DOCT_ID=1"