Mackbear
Registered User.
- Local time
- Today, 05:53
- Joined
- Apr 2, 2019
- Messages
- 168
Read the tutorial on Debugging in referenced link. Your code has a Debug.Print line with instruction on how to use it. Read that.
Never mind the inputs question. Code is using wildcards so this shouldn't matter.Code:'For debugging, remove the leading quote on the next line. Prints to Immediate Window (Ctrl+G). 'Debug.Print strWhere
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.
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!