Check Box On Condition

I have a field in my database that specifies the Road Classification.
Possible values include Freeway, Arterial, Collector or Local.

I would like to display the data in my reports a series of four possible
check boxes. Each check box would represent one of the possible values for
the Road Classification field.

Essentially if the value of Road Class is Freeway, then the freeway check
box would be set to enabled. Similarly the check boxes would become enabled
and disabled for the other three possible values as well.

Any help would be appreciated.

If I understand correctly, you could use check boxes with control sources like:
=[RoadClassification]="Freeway"
=[RoadClassification]="Arterial"
etc

--
Duane Hookom
Microsoft Access MVP


"Mike" wrote:

I have a field in my database that specifies the Road Classification.
Possible values include Freeway, Arterial, Collector or Local.

I would like to display the data in my reports a series of four possible
check boxes. Each check box would represent one of the possible values for
the Road Classification field.

Essentially if the value of Road Class is Freeway, then the freeway check
box would be set to enabled. Similarly the check boxes would become enabled
and disabled for the other three possible values as well.

Any help would be appreciated.