Check if client name exists in table

[Barbados]

Hi,

Using VBA (in Access), what code should I use to check if a client name already exists in a table.

Say, client name is "Smith", my table is called tblClient and the field name in the table is called fldClientName.

I just need to do the check, that's all.

Thanks.

 

[pr2-eugin]

You can use DCount.. Something along the lines of..

Dim countVal As Long
countVal = DCount("*", "tblClient", "fldClientName = 'Smith'")

If the countVal is >0 means there is a Customer with name Smith..

 

[Barbados]

You can use DCount.. Something along the lines of..

Dim countVal As Long
countVal = DCount("*", "tblClient", "fldClientName = 'Smith'")

If the countVal is >0 means there is a Customer with name Smith..

Works great. Thanks!

 

[pr2-eugin]

Glad to hear..