using controls in forms to control on/off functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a student progress report form which uses 3 radio buttons to
show if passing, marginal or failing. These are fields that are not in a
table and would be checked off by the teacher. I want the buttons to shut off
the use of the other 2 when 1 is selected. I tried using IIf then logic but
it didn't work. Any suggestions?
 
Add a field to your table to store a number (field size would be Byte).
Then add an option group to your form; using the wizard (the magic wand
icon) will prompt you for creating the items in the group. Bind this option
group to the field in your table that you just added.

An option group will allow only one choice to be selected, and will deselect
all others in the group. The value of the option group will be saved to
your table, so when you change records in your form, the option group will
change accordingly.
 
Thanks for the suggestion about the option group. I got the buttons to work
but when I create the report from the form, I am not seeing the results from
the buttons pushed in the group being stored.

Also, I am creating a field that will accept comments I want to use options
groups to create the button to make the choice and text boxes to define the
choice (ie 6. Test/quiz grades have been low.). I want the numerical choice
to go into the comment box and then teachers camn add additional text if
desired. I set the field to Text so that the comment fields will be related
(since Memo fields cannot be related to text). Any suggestions?
Thanks in advance for your help.
 
Back
Top