data type mismatch on query

[rry2k]

Hi,

I have the follwing code and am getting a dtm.
Everything is assiged the same type(int) but it's not working. vartest is passed from another form

Thanks for the help..Russ


Private Sub Form_Open(Cancel As Integer)
Dim dbs As Database, holder As Integer
Dim rec As Recordset
Forms![main_frm]![AAU Quote #] = vartest
holder = vartest
Set dbs = CurrentDb
Set rec = dbs.OpenRecordset("select * from [Main] where [AAU Quote #]='" & _
Forms![main_frm]![AAU Quote #] & "';&quot

 

[Databaseguy]

Access 2000 ??? If so, it's your set statement. Go to tools and set reference to DAO 3.6 and move it up the list. Or, write your code to be ADO compliant. Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy