Guest_imported
New member
- Jan 1, 1970
- 0
Why will this not work?
Dim strsql As String
strsql = "SELECT Asset_Label_Numbers.AssetLabelNumber " & _
"FROM Asset_Label_Numbers " & _
"WHERE Asset_Label_Numbers.AssetLabelNumber Like '" & Me!cboCategory.Column(0) & "*'"
Me.cboResourceID.RowSource = strsql
Me.cboResourceID.Requery
The drop has nothing in it. But the query returns records in break mode.
Dim strsql As String
strsql = "SELECT Asset_Label_Numbers.AssetLabelNumber " & _
"FROM Asset_Label_Numbers " & _
"WHERE Asset_Label_Numbers.AssetLabelNumber Like '" & Me!cboCategory.Column(0) & "*'"
Me.cboResourceID.RowSource = strsql
Me.cboResourceID.Requery
The drop has nothing in it. But the query returns records in break mode.