I'm in the process of setting up a form, and I have 4 yes/no fields that need to be in it. I want to group the fields so that only one of the yes/no fields will be able to be selected. The fields are: Pass, Fail, N/A, and obsolete.

I tried setting up an option group, but I can't seem to get the information to filter back to the table that is capturing the data.

Any help?

You might be better off using a ListBox.

If you want to use the option group, you need all the boxes to refer back to one field in the table. The option group will return numbers, and each number represents the option:

Pass = 1
Fail = 2
N/A = 3
Obsolete = 4

   In subsequent reports, you can use Select Case to substitute the values:

Select Case Status
 Case 1
   sVariableName = "Pass"
 Case 2
   sVariableName = "Fail"
...
End Select

Me.Text1 = sVariableName

   Anywho, is that not what you want? Do you want the option group to pass text? I think it can do this. If not, just create an after update event for the status field (so I am calling it) to push a text value into a txtStatus field in the table.

Does this help?



mmcdonal

It helps quite a bit. Thanks! I'm new to option groups and managed to get one set up yesterday afternoon, but I do need the text for the values, to pull reports.

Thanks!

Yes, MMcDonal is correct. Instead of four yes/no fields, you simply need one field of type number (byte) that will hold 1 through 4. The option group will work with that field.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

When you pull a report, you can sort by the option numbers, and replace the number values with text values at runtime.



mmcdonal

Thanks again for the help! This is not my database, I'm just working on a portion of it.