I applied your changes and it still didn't work. Its almost as if the Branch_Number and Branch_Name aren't querying the data. The combobox is pulling down the accurate data, but there are no results.
The PK combobox still works, but its the other two that sometimes return the incorrect value or don't return a value at all.
bman414
Last Activity: Jul 24 '18, 07:54 PM
Joined: Jul 24 '18
Location:
-
thanks for the quick response!
I'll give this a try, when I originally made the form, I used similar code and it worked perfect when I searched the data using either of the comboboxes. So I'm not sure if that's the issue, but I'll give it a try.
Thanks,Leave a comment:
-
Access combobox doesn't return correct data
Hi all,
I'm trying to build an access form with a combobox that can search on multiple columns. I built it once and it was working as expected, then I changed the data source and it stopped working. I then tried building the old one from scratch.
There are three comboboxes that I'm using as a search function. I use the following columns (PK) Primary Key, Branch_Name, and Branch_Number.
The PK combobox works...
No activity results to display
Leave a comment: