Search results
-
M
VBA Coding to filter a form based on a search Combo Box
@cheekybuddha, the control source box is empty. I tried changing this to the field "OrderStatus" and it would filter the entire form to "Order ID 1" and then any change of the search box would only change the status of Order ID 1 and not amend the filter. @theDBguy, I am afraid I do not...- M3opa
- Post #7
- Forum: Modules & VBA
-
M
VBA Coding to filter a form based on a search Combo Box
Thank you for your reply. I think we are almost there. I no longer get the "#Name?" all over my record boxes however, when using the search filter box, no records appear at all. I have tried various tweaks of the code you gave above to no avail. Could this be because of the " ' " line of...- M3opa
- Post #3
- Forum: Modules & VBA
-
M
VBA Coding to filter a form based on a search Combo Box
Hi all, I am very new to access and just dipping my toes into VBA coding. I am trying to code a combo box to filter my form on the after update event. Based on my searches in forums and online, I currently have the following code though it is not working for me. Private Sub...- M3opa
- Thread
- Replies: 13
- Forum: Modules & VBA