Radio Buttons and Screen Reports

[camelk]

I have a problem with radio buttons showing-up correctly in a screen report. The form uses 2 radio buttons to input data into a table. (one button for M.D., the other for D.O.) The fld in the table that supports this is "Title". The data is entered into the table as 1 for M.D., and 2 for D.O. My problem is that when I click the appropriate radio button on the form and then run a screen report, the screen pint shows both buttons as darkened. (To get the screen report, I did a 'save as report' for the form.) Why is this happening? How do I get the screen report to show that the correct button has been darkened.

 

[SgtJarrow]

If I were in this situation, I woudl create a report showing the same data and then call this report to print with instead of saving out the form. While creating the report, use a text box instead of the radio buttons for the Title. Then, in the Detail.OnFormat property, use the following code:

If "tablename"![Title] = 1 Then
Me!"TextBoxName" = "M.D."
ElseIf "tablename"![Title] = 2 Then
Me!"TextBoxName" = "D.O."
End If

This will give you a report with the title actually written outinstead of the radio buttong. plus, by using a report instead of a save as form, it will look a WHOLE lot cleaner. If you need mroe help with this, please let me know.
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." Albert Einstein.

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@citi.com

 

[camelk]

Thanks for your help.
camelk