strWhere = strWhere

[spartansFC]

Hi

I've been trying to sort out this filter by form but can't seem to get it to work the way i want, the search form is one i got from Allenbrowne's website, it works great and the form does filter but it has the wildcard "like" statement in, i need to remove that from the strWhere code so that it only looks at what is selected in the cmbChildStatusSelect.

I've tried just removing the Like ""*" from both sides of the ChildStatusSelect but that creates an error. Can anyone reconfigure the code below so that it just looks at the specific selection in the combo box.

strWhere = strWhere & "([ChildStatusDesc] Like ""*" & Me.cmbChildStatusSelect & "*"") AND "

thanks

Mikie

 

[jrbarnett]

Firstly:

this code adds the condition in your code to whatever is in the variable, so it will need to be a valid SQL WHERE clause.

Secondly, at the end is the word " AND ".
This will need to be removed if this is the last condition, or another one will need to be added later so that overall, the final where clause is valid.

John

 

[MajP]

So that you can debug, before running your query always debug.print your sql string so you know exactly what is resolved.

strWhere = ...
debug.print strWhere
'look at it to see it makes sense

strWhere = strWhere & "([ChildStatusDesc] = '" & cmbChildStatusSelect "'") AND

 

[spartansFC]

thanks for the help jrbarnet and MajP, got it working... yay

Mikie