I did not write these functions but it has very easy code implementation and I have have used is numerously over the years (it is very old but still working in Excel and Access 2016) - I hope someone else can benefit from it as I have
Example code usage
Private Sub cmdButton_Click()
On...
Does not work, no error, nothing - in fact the combo box still displays drop down values properly but no impact on results, nothing. As if code were rem'd out
Dang
Thanks again for responding
That appears to be what I am looking for - I am out of the office at current and will give it a test tomorrow. My fingers are crossed
Hello and thanks for responding and yes there will be duplicates. Example - cboBathTypes (fixed data) would Tub, Shower, Tub & Shower. Customer - Joe Smith main bath [BathType1], has a tub, master bath [BathType2] has a shower. Search form has cboBathTypes whereas I am searching all customers...
Thank you for responding. This is of course example situation. The object hear was to change code filter data from a singular combo box not create 3 individual combo boxes but thanks anyway.
As for normalizing the tables, I agree but believe but even so I would still end up at the same moot...
The combo boxes work perfectly and has already combined the data - that is not the problem. The problem is that the code does not know if the value selected from the combo box is coming from [BathType1],[BathType2],[BathType3]. If the data from the combo box happens to be from field...
Thank you both for responding
Combo boxes are working fine it is in the VB filtering I am having the issue
Three different bath types due that one customer may have three different baths / type (main = bath (master = shower)) etc and they are in the same table. If I were not use a union how...
I have a search form with multiple cascading combo boxes. Most combo boxes record sources are linked to a singular table field whereas I am using this code to filter results
Please Use Code Tags
Function SearchCriteria()
Dim CustomerType As String
Dim Task As String
Dim...