I'm going to bet this is simple, but a search of multiple ways to say this has turned up a lot, just not an answer that is specific.
I have two tables, one table (1) hold three fields, one of those fields is the master key (index). The other table (2) has a field which I want to lookup from table 1, that part is working. In the combo box I get all three fields displayed as I make my selection. I want to copy the other two fields as text at the time the lookup index is selected. I do not what the fields to automatically update each time the table is displayed. I have looked at update macros, I've looked at VBA. This seems so simple to me that I have to be missing something obvious. Any help would be much appreciated. Thanks