|I have a form in access that I want to populate with data from a table. I want the data be to populated automatically based on the 'Code' that is selected in a combo-box in the form that is being looked up from the table.|
So when I go into the form, select the code 'HIST1000' from the combo box, I want the other fields in the record with the code 'HIST1000' to be populated into (ideally text boxes) in the form with the information from the associated record in that table.
So far I have made a query to find the record that I select from the code in the combo box - so I have the information there. I just don't know how to go about getting this information into the form - ideally into text boxes. Sorry if I've explained this really poorly, I'm happy to try and clarify if I'm not making sense!