VBA Combobox Rowsource Wildcard

[SeadnaS]

Me![sizecombo].RowSource = "SELECT DISTINCT Size_Type FROM " & Me!classcombo & " WHERE Size_Type LIKE " & Me!classcombo & "_" & Me!type & "_*;"

I want a wildcard! Why does the * symbol not work as a wild card here?

 

[SeadnaS]

Is there an alternative way to do what I want here? I want to limit the results of my combo box to records that contain (Me!type) and (Me!classcombo) the wildcard replaces numbers and they are different for a lot of the records. I don't see why I cant use a wild card here.

 

[dhookom]

Try change you code so that it can be debugged:

Dim strSQL As String
strSQL = "SELECT DISTINCT Size_Type FROM " & Me!classcombo & _
  " WHERE Size_Type LIKE " & Me!classcombo & "_" & Me!type & "_*;"
debug.print strSQL
Me![sizecombo].RowSource = strSQL

You can set a breakpoint in your code so you can copy the strSQL value from the debug window and paste it into a new, blank query SQL view.

Duane
Hook'D on Access
MS Access MVP