Filter Records Based on 4 Combobox and 2 Textbox

June7 said:
Read the tutorial on Debugging in referenced link. Your code has a Debug.Print line with instruction on how to use it. Read that.
Code: 
        'For debugging, remove the leading quote on the next line. Prints to Immediate Window (Ctrl+G).
        'Debug.Print strWhere
Never mind the inputs question. Code is using wildcards so this shouldn't matter.

Code is referencing VendorName field:

strWhere = strWhere & "([Vendor Name] Like ""*" & Me.cbvendo & "*"") AND "

The combobox provides value like "*4*" which is the vendor ID. Look at the combobox RowSource, ColumnCount, ColumnWidths properties to see why.
Click to expand...


I got it to work now thanks for the explanation! :):):):) Vendor is now searching, now we fixed one, there is another one that came up! The Notice ID search on the APWorkflow1 form is saying No Criteria even if I know the notice id exist within that table. On the APWorkflowHistory form it works fine, I don't know if I accidentally changed something but I looked into the codes and they are the exact copy.... I attached the DB thank you so much I really appreciate it!
 

Attachments

Missing NOT:

If Not IsNull(Me.txsearchnoticeid) Then

If you had set breakpoint in the procedure and step debugged, that should have jumped out at you.
 
June7 said:
Missing NOT:

If Not IsNull(Me.txsearchnoticeid) Then

If you had set breakpoint in the procedure and step debugged, that should have jumped out at you.
Click to expand...


Thank you so muchhhh! It is up and working now, Don't know how to set breakpoint and step debug though, I apologize if I am missing what is obvious to you guys, I am new at this and just trying to learn the stuff. I really appreciate your help guys!:):):):):)
 
As already advised, for debugging guidance, review the link at bottom of my post. Find other tutorials on the topic.
 
You must log in or register to reply here.

Similar threads

F
Solved Form with subform filtered by two cascading combo boxes and a checkbox
2
Replies
26
Views
639
Faoineag
F
P
Solved Trouble creating a filter on a form displaying records built in a query
Replies
4
Views
600
p_bij
P
H
Solved Search across multiple fields
Replies
8
Views
817
Harry Paraskeva
H
H
Problem with Search Boxes
2
Replies
24
Views
1,282
Pat Hartman
P
A
Filter Records
Replies
1
Views
363
June7
June7

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom