Recordset FindFirst

[Praveenevg]

Hello,



Is there a way to use a variable to define the value of the field in FindFirst?


Set GNRC = CurrentDb.OpenRecordset(strSQL)

GNRC.FindFirst "FIELD1 = FIELDVALUE"

How can we pass the FEILDVALUE dynamically? Can we pass a variable to FindFirst?

[June7]

Certainly, concatenate variables. Variable can be a declared object in VBA or reference to a control on form.

GNRC.FindFirst "FIELD1=" & MyVariable

If FIELD1 is text, use apostrophe delimiters, dates use #.

GNRC.FindFirst "FIELD1='" & MyVariable & "'"

GNRC.FindFirst "FIELD1=#" & MyVariable & "#"