I have a small form in which I need to query an Excel sheet with data in it. I have an application where I need to look up vehicles by either tag number, vehicle number, or radio id. Entering any one of the 3 inputs, returns all the other data assigned to that vehicle. So if I type Tag # ABC123, it returns data to all the other fields like vehicle color, make, model, radio id, car #, and its assignment, etc.

I have built the form in visual basic, but for the life of me cannot figure out the code to do this.

Can someone help me?

Thanks