Option Boxes

[Pooklet]

Hi there,

I have to use quite a few Option Boxes on my Database. The problem I have
is that the selection made should print at a specific place in a report.

Basically what I have is about 30 government forms (I am automating the
filling in of these forms) - for a private company.

I want to use the functionality of a Option box (so that only one option can
be chosen) but I want to have an "X" printed on the form in the place where
the box is situated on my report. If a specific record is not selected then
the area must be blank (Only the selection must print the X)

Any help would be appreciated.

 

[Steve]

Make the boxes on your report unbound. Name your boxes on your report Box1,
Box2, etc. On your form, create an option group named MyOptionBoxes using
checkboxes. Use the wizard and the wizard will keep adding options until you
get as many as you need and they will be assigned 1 to Total # of boxes.
Launch the report from this form. Put this code in the report's Open event:
Me("Box" & Forms!NameOfYourForm!MyOptionBoxes.Value) = True
This will check the box on your report that corresponds to the box on your
form you checked.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Pooklet]

Thanks Steve,
I will give it a go this morning.