Why am I getting a Type mismatch error when opening this recordset

[Guest_imported]

Trying to open in Access 97 code

Dim DBS As Database
Dim rst As Recordset
Dim strsql As String
Dim MaxID As Long
Dim NewLabelCount As Long
Dim NewLabelID As String
Dim x As Integer
Dim MaxIDLen As Long


txtLabelCount.SetFocus
NewLabelCount = txtLabelCount.Text

Set DBS = CurrentDb
cboCategory.SetFocus
strsql = "Select MaxAssigned from Asset_Label_Sequence where Prefix = '" & cboCategory.Text & "'"
Set rst = DBS.OpenRecordset(strsql)

 

[jebry]

Hi!

Is prefix a text field? If it isn't then you need to drop the single quotes and everything after and including the last ampersand

hth Jeff Bridgham
bridgham@purdue.edu