Open form criteria string

[FranS37]

I'm getting a "type mismatch" erro on this line. Auditor code is a number and payment month is a date field that I've formatted into "mmmm yyyy". It doesn't open the form, but fails here.

Any help is appreciated. Thanks.

DoCmd.OpenForm "frmAuditorLookup", , , "[auditor_code] = " & Me.Auditor And "[paymentmonth] = "" & Me.PaymentMonth]

 

[scriverb]

Try this:

DoCmd.OpenForm "frmAuditorLookup", , , "[auditor_code] = " & Me.[Auditor]  & " And [paymentmonth] = "" & Me.[PaymentMonth] & """

Let me know if that works for you.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???