Hi there ;--)
I am using DAO in my project and an Access database.
What I am trying to do is:
I am reading the primary key of a record in a variable.
iPrimaryKey = CInt(frmList.FlxList.Text)
Then I create a recordset with my dbs database variable with only this
strquery = "SELECT * FROM tbAdressen WHERE [AdresId] = ' " & iPrimaryKey &
" ' "
set rstAdressen = dbs.openrecordset(strQuery,dbOpenDynaset)
The problem is that I continuously get an error saying :
'data type mismatch in criteria expression' (error number 3464)
Whatever I do, I can't get it going. Any suggestions what I did wrong in
the select statement.