Check Box On Condition

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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
 
Back
Top