I'm an intern at a manufacturing facility. I've never used Access before but I'm willing to learn and appreciate all help!
GOAL: select the IC number from the combo box and have 5 text boxes auto fill.
AS OF NOW: I have a table made for the IC number drop down. The columns represent the fields that need to be auto filled.
WHAT I THINK THE NEXT STEP IS: Making some kind of query to link the combo box entry to the text boxes? Some VBA where the control source is equal to my query? I have tried changing the text box control source to equal columns from my drop down but that did not work.
NOTE: the blue font in the first image represents the text boxes that need to auto fill when I select the IC number from the drop down. The second image is my table from which my combo box is generated. The acronyms are for the two tests on this form. Sorry about the abbreviations in the table header.