Question DCount problem

[byTimber]

Can anyone help here:

Table is named tblLVR
Field is BusinessName

I want to check the previous existence of this name in the table.

I assign a variable tBusVar to the entered name on it's changed event
and write the following code to see if it is already in:-

If DCount("[BusinessName]", "tblLVR", "[BusinessName] = " & tBusVar) > 0 Then
MsgBox "This current record is a Duplicate"
End If

Run_time Error :'2471':
The expression passed as a query parameter produced this error '<Name entered>'

I can't understand what is happening here. Grateful for any help....

 

[pbaldy]

If it's a name (text), the syntax changes:

http://www.mvps.org/access/general/gen0018.htm

 

[byTimber]

Thanks for reply Paul, but tBusVar is a variable and not actual text; how would that play with DCount and DLookup in my situation?

 

[pbaldy]

It would be the same as the form example, replacing the form reference with your variable.

 

[byTimber]

Got it! - Thanks Paul. Best wishes, Roger ..

 

[pbaldy]

Happy to help Roger!