FindFirst with two conditions

[Mister-B]

Hi there,



I'm trying to use rs.findfirst to find the first record that meets two conditions:

rs.FindFirst "Buchnummer ='" & Me.txtBuchnummer & "'" And "Ehemalig ='" & "False"""

However I try, I just can't get the synthax right. Can anybody help, please?

Regards,
Martin

[June7]

The AND is literal text and must be within quote marks. Also, if Ehemaliq is yes/no field, don't use apostrophe delimiters. False is an intrinsic constant and holds a value of 0.

rs.FindFirst "Buchnummer='" & Me.txtBuchnummer & "' And Ehemalig=False"

[Mister-B]

Thank you very much. That works great