Search results

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...

Yes, the list box you have would work if in only returned results of tools that had that combination. The problem is that with only one list box, I will have hundreds of tools and to have to scroll from top to bottom and select from it may be a bit tough to remember what tools you have selected...

nope, the way it originally was had a drop down menu that pulled info from a specific column and searched only that column. The only way you would know if that tool was used in that column was to scroll through the drop down menu and locate the tool # in the list. I guess I think it would make...

KeithG... I have my Drawing Information search criteria nailed down for sure now. I want to have 8 drop down boxes that pulls its drop down menu from "Tooling Information" table, NC Tool # field. That way any tool # shows up as a possibility for the search and can use any amount of the boxes...

I put the cart before the horse on this one for sure. What makes the most sense to me is having multiple drop down boxes so a user can either select an entry from them or type in the tool # in each one of them. If there are more then one entry in the drop down boxes, then the search considers...

I am getting myself confused now again. I think I'm creating a monster. On one hand sometimes I may want to search for all the drawings that use a particular tool number, while other times, I may want to search for drawings that use varying quantities of different tools, up to a max of 8 tools...