How to search between two or multiple fields in Combo box
Hello,
I need to know some VBA code that will allow me to search or switch between 2 fields inside one Combo box.
Below I have attached example file to help explain my question. In Combo box of a Form I am wanting to search and put a city code direct in field cityCode OR by city Name, so not just by one field citycode. I’m sure this is possible, but I have no idea how to do it?
I'm a VBA newbie any written code in a given example would be appreciated.