Recent content by mogul0212

Yes, exactly. I tried modifying this line to take out the Or and put in And it doesn't return any results even if I only use 1 search box. If IsNull(strWhere) = False And Len(strWhere) > 2 Then strWhere = " Where ([Outside Tool #1]in (" & strWhere & ")" & "Or [Outside Tool...

Ok, I changed the wording to get rid of the strToolSearch and replace with the strWhere in the code. Now how would I add multiple searchs up to 8 combo boxes that would include an "And" phrase to make a selection include only those records that all of the tool #'s entered in the combo boxes...

Just trying to learn the syntax of the code to get it working. I've come to realize that I'm not quite up on the code. To be honest, I'm completely lost on how to do it.

Here's my database so far. I've added the Drawing Information Search form. Trying to get multiple combo boxes to have search criteria criteria to search all of the Outside/Inside tool boxes for a particular tool # if used in any of the columns.

Hmmm, changed that line, and still get every record back

KeithG It's returning all results, like it's not searching that criteria at all.

KeithG... When you get time, could you possibly try to clarify the line of code. I'd really appreciate it.

Somoething close to this? If IsNull(Me.cmbToolSearch1) = False And Len(Me.[cmbToolSearch1]) > 1 Then strToolSearch = strToolSearch & "'" & strToolSearch & "'" & "," End If If IsNull(strToolSearch) = False And Len(strToolSearch) > 2 Then strToolSearch...

Ok, I thought that what that did, but must be missing something. Can understand being swamped, no problem. I'll try playing with that more following your example, all the quote marks and brackets confuse me.

Here's what I believe to be the code, but it's not working.... any ideas? If IsNull(Me.cmbToolSearch1) = False And Len(Me.[cmbToolSearch1]) > 1 Then If IsNull(strWhere) = False And Len(strWhere) > 2 Then strToolSearch = strWhere & " AND ([Outside Tool #1]='" &...

I'm updated the form to have the criteria I want, I haven't deleted the older tool combo boxes yet the code for their search yet, but I'm confused about that line of code you gave me. I see the new string name you gave, strToolSearch Does that mean I need a line at the begining like Dim...

hmmmmmmm I'm not quite getting that...

So far I have this line of code If IsNull(Me.cmbToolSearch1) = False And Len(Me.[cmbToolSearch1]) > 1 Then If IsNull(strWhere) = False And Len(strWhere) > 2 Then strWhere = strWhere & " AND ([Outside Tool #1]='" & Me.cmbToolSearch1 & "')" Else...

If I create an unbound combo box with a record source of "Tooling Information" NC Tool #, and name each combo box like cmbToolSearch1, cmbToolSearch2, etc... How does that line of code work you talked about?

Yes, all the tools would show up in the combo boxes yes and yes you'd have to scroll through them as well, but when you select it in that box, you'd be able to see each selection you made, in the list box you wouldn't be able to see each search item you selected, which could be confusing for...