Syntax error with DLookup

[Ronaldo9]

I would appreciate any help with this Dlookup function.

This part of a function that checks whether there is a duplicate in the table.
A duplicate record here is a record that has the following:
an already existing Card number AND (the status of the card = activated OR pending)

I have the following code, but I get a compile error: Expected: list separator or )

DLookup("CardID", "tblCards", "CardNumber = " & Me.txtCardNumber"AND ([CardStatus] = 'Activated' OR [CardStatus] = 'Pending')")

Thank you in advance,
Elias

 

[pbaldy]

You don't have an ampersand between the form reference and the rest of the string.

 

[Ronaldo9]

Can't believe I missed that..
Many Thanks

 

[pbaldy]

No problemo!