Create Check Boxes From a Table

[GeekyGirl]

hello,

I am creating a form to hold information about sample images that relate to sections of a class I teach.

I have two reference tables that contain a list of Categories and Subjects. Instead of a Combo Box, I want to have an option group of check boxes where the values of the list become the check boxes.

How can this be set up so that the values are pulled from the table instead of my retyping the list using the option group wizard?

Also, in regards to this same aspect...
I originally had the field in the Image Table to correspond to the CategoryID (number - long integer) but will that still work to hold multiple IDs that would be created from checking off multiple check boxes or do I need to change how that field is set up.

 

[novoiceleft]

Hi

I am only a beginner, but I had a similar situation.

I first made a query based on the Table values. Then I referred the Option Wizard to the query.

An option Group only allows you to make one choice of the boxes. If you want multiple choices, you might have to build a sub-form.

Hope that helps

NoVoice