Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo Box Row Source Problem

Status
Not open for further replies.

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top