If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Option Boxes
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. |
#2
|
|||
|
|||
Option Boxes
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 "Pooklet" wrote in message ... 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. |
#3
|
|||
|
|||
Option Boxes
Thanks Steve,
I will give it a go this morning. "Steve" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|