I'm trying to use the option groups to allow a user to select different options on a form.
The options are on a 2nd table linked to a main table, I want to be able to run a query later to find all records from the main table with values from the 2nd table. However the option groups only allow the user to choose one option; they need to be able to choose one or more - is this possible???
An option group allows only one choice of many. It is bound to one column in a table. You can skip the option group if you have more than one column of data. Create a checkbox for each column separately. Use the Check box tool rather than the option group tool.