Help Needed With FindFirst - Multiple String Critera (1 Viewer)

[q582gmzhi]

Hi,

I am having problems using FindFirst with multiple string critera.
If I use one critera it works fine, but two I can't get to work.
Part Of The code is below.


strCriteria = "NewProp = True" And FinCoID = "MyBank"

rst.FindFirst strCriteria


Many Thanks

Darrell...

 

[shay]

Try...


strCriteria = "[NewProp] = True And [FinCoID] = 'MyBank'"

hth

shay

 

[q582gmzhi]

That Works - Thanks - No Msg

.