I’m using VBA to access excel values; but the language isn’t the important thing here.
I have in my data some client information. They have different informations, informations, such as Name, Phone, CellPhone, etc.
In the search window I created, there are several fields that the user can input into. There is the name field, phone field, cell field, along with some others.
When I click the find button, the program should either fill the other fields accordingly by looking up the partial information the user provides, or return error if there is no match.
I can’t solve this problem; how am I supposed to check when the use inputs a Phone that doesn’t have the corresponding name inputed? I can think of many ways to handle this, but what is the best way to handle this problem for any tow mismatching inputs?