Search results

Yep, null fields. Thanks

Another question... I have my form set up to return the results from these multi-criteria searches on the form itself (the same form you were helping with above). So sometimes, there may be 100s of results to flip through using the next button. I also am adding in a report feature for this...

Nevermind, I missed the part about the combo box being tied to a checkbox field in the table. You'd think since it was my DB that I would have noticed that before asking...:banghead:

Yep, that works. Question, though... If other combo boxes don't necessarily need the "default" value put in for the string to exclude it, then why does this one? Couldn't I just remove the part about the "N/A" and the "99" and get the same result? The checkbox would have just asked the user...

One more question... The code below can easily be altered to use with combo boxes and text boxes. How would you alter it for a checkbox? If Len(Me.RoomCombo & vbNullString) > 0 Then If Len(strSql & vbNullString) > 0 Then strSQL = strSQL & " AND " strSQL = strSQL & "([Room] = '" &...

I'm just glad you decided to help even though you couldn't test.

That did it. thanks for helping!

Nope. :) And it shortened my keyword by removing the last letter from it...

When I run it, it gives me this error: Run-time error '3075': Syntax error (missing operator) in query expression '[Item Description] Like "%mykeyword%' AND AND AND'

I've got some code from somewhere else that now works... I'll try this as it seems simpler. Another question, though. I originally used an asterisk so it would take the user-typed keyword and find results in the table, but I only had it at the end of the statement (see my original code...

Yes, it can return a single record or multiple records. The only reason I used a form is for ease of use for the user to edit records when they populate. The plan was to add in a report feature also.

ANSWER: The code you seek (if you had the same question I did, anyway) can be found in post #11. Not sure if this is the right place for this question, so please forgive me if it is. It does involve VBA, but also involves forms and searches. Here goes... I have a search form with blank...