I am new to access and I have created a option group with 4 options in a form:
Option 1: 0-8
Option 2: 9-12
Option 3: 13-14
Option 4: >=15
Each of the above options has a seperate bound text box, i.e a total of 4 text boxes one for each option. I would like one of the 4 text boxes, created in my table/query and now part of my form, to be activated when the option related to the text box is selected so that data can be entered in this text box, whilst all the others 3 text boxes remain deactivated, therefore only allowing one entry for the 4 options and only one selection of each of the 4 options. How do I link each bound text box to each option within the group.
Option 1: 0-8
Option 2: 9-12
Option 3: 13-14
Option 4: >=15
Each of the above options has a seperate bound text box, i.e a total of 4 text boxes one for each option. I would like one of the 4 text boxes, created in my table/query and now part of my form, to be activated when the option related to the text box is selected so that data can be entered in this text box, whilst all the others 3 text boxes remain deactivated, therefore only allowing one entry for the 4 options and only one selection of each of the 4 options. How do I link each bound text box to each option within the group.