I am getting a message that I have a 'data type error in criteria expression'. In the Access database, the issuenumber is defined as an autonumber, which is a long integer. The variable gintIssueNumber is define as 'Long' in a public statement.

This is the line that is giving me the error:

rst.Open "Select * from tblLog WHERE issuenumber = '" & gintIssueNumber & " ' ", cnn


This is the code that fills 'gintissuenumber':

gintIssueNumber = cboIssue.Text

Is the '.text' giving me the problem? If so, what can I use in its place?


smh