>Hi
>This is probably a no brainer but I am having trouble getting a findfirst
to
>run. Using
>    rst.findfirst "[firstfield]=" & rst2![firstfield]
>I get an error that the Jet engine doesn't recognize 'albert' as a valid
>field (albert is the literal value of [firstfield] in this case). If I use
>the indexed id value instead of the text string the syntax works fine, but
I
>want to use the text string.
>I just ordered getz's book, it has been praised loudly everywhere I look.
In
>the meantime I have spent way too much time with what should be the
simplest
>of procedures.
>Any help will be greatly appreciated.
>thanks
>David DeMeglio