Here is what I need to do. First of all the data is not normalized so don’t flame me I didn’t start this.
I have a list box which contains a First Name and Last Name. When you click on it this is what I want to so:
Run a VBA procedure that will pull 800 + items from multiple tables and populate them into text boxes.
Ordinarily, you could use a regular query to do this but in this instance you cant due to the field limitations on Access.
There are 5 tables I need data from and the only real variable is the name.
How can you do this in VBA?