According to naming convention your variable strCustID is a string, then change you SQL statement to:

strSource = "Select * From Contacts Where[Customer ID] = '" & strCustID & "'"



If strCustID is a numeric type then change you SQL statement to:

strSource = "Select * From Contacts Where[Customer ID] = " & strCustID


Regards,

------------------

Serge

Software Developer
[email protected]
[email protected]




[This message has been edited by Serge (edited 08-03-1999).]