VBA script (2 Viewers)

[niallmc]

I've been working on this for a few days with no joy. I have a vba form with 3 combo boxes. I am trying to do a filter for search purposes. The filter works fine if one field or ALL fileds are input. I'd like to search on ONE or ALL filelds. Any suggestions for what to do?

Here is my code
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmOpen"
stLinkCriteria = "[Code1]=" & "'" & Me![Code1] & "'" & " AND
[Code2]=" & "'" & Me![Code2] & "'"

DoCmd.OpenForm stDocName, , , stLinkCriteria

Thanks
Niall

 

[ICUH8N]

You could make them active/inactive with a checkbox, and then check to see if they've been used by going

if chkCombo1
then strQuery = strQuery & txtCombo1
end if

basically (no pun intended) make a string (strQuery) which will eventually become your query, and concatenate the search parameters (from txtCombo1) onto it if the input box has been used, then concatenate strQuery onto the actual search string.
I did this ages ago to use a load of combo/dropdown/text fields to query a DB, and it worked beautifully. Dunno if that's exactly what you're after.

 

[niallmc]

You could make them active/inactive with a checkbox, and then check to see if they've been used by going

if chkCombo1
then strQuery = strQuery & txtCombo1
end if

basically (no pun intended) make a string (strQuery) which will eventually become your query, and concatenate the search parameters (from txtCombo1) onto it if the input box has been used, then concatenate strQuery onto the actual search string.
I did this ages ago to use a load of combo/dropdown/text fields to query a DB, and it worked beautifully. Dunno if that's exactly what you're after.

I appreciate that, I'll give it a bash tomorrow