FindFirst String Variable Syntax 1

[xweyer]

I'm having problems getting the syntax right in the following situation.

I have a string variable that I want to use to search a dao recordset. Group is the field I want to search and stXgrp is the variable.

I need something like the line below but in the correct syntax.

rst2.FindFirst "[Group] =" & stXgrp

 

[Eupher]

Hi, xweyer,

Try this:

rst2.FindFirst "[Group] = '" & stXgrp & "'"

HTH,

Ken S.

 

[xweyer]

Thanks Eupher,

That did the trick.