I have a subform that has different questions (number and question) on it dependant on what value is selected from a combo box in the main form (EquipmentType).
Ideally I would like to have the questions automatically fill the appropriate caption from the question table. Is this possible?
To do this you would need to match the EquipmentTypeID selected in the combo box with the foreign EquipmentType ID in the Question table and therefore display/ unhide the correct number of questions and fill the captions with each question from the Answer table
Not sure if you can use labels like controls, however would be the best way to do it if possible as the labels will then relate to answers for the answer table