Linking Raidal buttons or check boxes

[Stephanie T.]

I hope this is a simple one. Just to note, I'm on Access 97.

Is there a way to create a two check boxes or radial buttons that are linked so that only one can be checked at a time. For example: I want the date entry person to be able to check a box that says "open" if a dispute it still open, and then click "closed' once it has been resolved - thus moving the check from open to closed. I don't want both to be able to be clicked at once or it would throw off the data.

Thanks,
Stephanie

 

[Stephanie T.]

Changing value in from an option group

Sorry, I got this one figured out, but what I don't know how to do is set it up so that that values that get reported are not in integers, but in words.

I have an option group with two radial buttons. The default is for "open" and once the dispute is worked out the data entry person can click on "closed".

I've set up the query to run a report that would show me all of the "open" disputes, but the report shows them all as "1", of course that is the "value". I read in one of my books to set up another table where the values correlate with the words open and closed, but it doesn't make a lot of sense to me. Another book, or perhaps MS Help suggested creating an expression to do this, but I'm rather new at this and don't know how.

Any help is greatly appreciated.

Thanks, sorry for the first post and confusion,
Stephanie

 

[glynch]

If you just want to see the text displayed on a report, you can easily manipulate what is displayed. Try this:

In the control source of the report textbox for the dispute status, enter: =iif(optDispute = 1,"Open","Closed").

HTH

 

[Stephanie T.]

Dear HTH,

Thank you for the suggestion. I tried it and when I go from design view to report view I get a small dialog box that says "optDispute" and wants me to insert something. If I put in the numeral 1 it shows everything as "Open", if I put in the numeral 2 it shows everything as "Closed". Is something missing in that line of code?

Thanks,
Stephanie

 

[bradcccs]

It looks like you took Glynch's expression verbatim.

=iif(optDispute = 1,"Open","Closed")

is the correct expression as Glynch posted. But you will need to change the "optDispute" to the field name that is storing the 1's and 2's

ie: Your option group on the form must be bound to a field in your table. The "optDispute" part of the above expression should be the name of the field in the table.

HTH

Brad.


***
Yeah, what Pat said

 

[Stephanie T.]

My field is called "Dispute" so here is the new code:

=IIf([Dispute]=1,"Open","Closed")

Now I get an "#Error" message on the report. I have been entering this code in the control source for that field in the report. Should I be entering something in the Query that drives that report?

Thanks,
Stephanie

 

[Stephanie T.]

Pat,

You come through again!!!

Thank you!
Stephanie