Module Creation (1 Viewer)

[dedwards1960]

I have created a form that takes data from a table/query and displays the information in the form. I have some check boxes on the form for gender.

The only thing is the table has this information in one column called sex.

I would like to create a module that will look at the information in the sex column and then put a check in the appropriate check box to indicate the correct gender.

Is this possible? Or is there another way to do this.

Thanks for all your help

 

[Pat Hartman]

Check boxes generally indicate multiple choices. Sex is usually single choice (I know some people will argue with that) and so should be depicted with a combo or an option group rather than multiple check boxes.

To make the option group work properly, you need a numeric value for the code. I would suggest adding an ID column to the sex table and assigning a numeric value to each code. You can then easily use an option group (the wizard will walk you through the process). Or, you can leave the values text as they are currently but use a combo box to choose. My recommendation is the combo so you can stick with your present table structure.