Data Type Mismatch

[msgt]

I'm using Access 2010 connected to SQL 2008 server (64-bit). I created a database table with one of the fields as numeric (18,2). I linked the tables to the Access project. Created a form with a comb box and another text box. I can populate the comb box with a sql query. Using an AfterUpdate event procedure, I define the variable used in the procedure:
Dim strSQL As Single (I've tried Double, Currency)
strSQL = "Select dbo_InvMaster.gap from InvMaster where dbo_InvMaster.partno = " & GBL_partno & " ;"

What data type should I declare in the event procedure to match the SQL data type numeric?

 

[vbaInet]

You are passing a String, strSQL has to be String.

 

[msgt]

Thanks for the quick reply. I got past the data type mismatch error.

 

[vbaInet]

More hurdles ahead. Good luck!