I've looked around the internet a bit already and can't seem to find an answer to my problem. I am new to access so I may be approaching this all wrong. I have 2 drop down menus ( "Panel" and "Inverter" for now ) that are populated from two different queries shown below (some values are arbitrary for now).
What I want to do is have my first text box filled with the associated watt value for the panel in the "Panel" dropdown menu, and have the second text box filled with the cost. Two more text boxes will be added to do the same thing for the inverter drop down menu. More text boxes and drop down menus will be added later. Ultimately I am trying to have a list with the cost of all the components that will be selected as well as the wattage for components that I need to know the wattage for. I intend to do calculations with these numbers to finalize a cost based on watts and/or component cost. Apologies if I am confusing anyone. I am having difficulty wording this.