option groups

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help! I am trying to design a form with option groups where, depending on
which option you select brings up additional options. For example: The DB
that I am building has about 12 different reports that can be printed for
each record. Some reports can have several different ways to get the
information. When the user selects a record of training recieved I would like
to be able to select from a list box That opens on the current form with
different options (which record to print and also be able to select which
category they belong to). Some of the reports though are straigh forward and
dont need any other options. The goal is to be able to print any report from
one place.

I have a DB that has this function but its a secured program and I dont know
where to get support. It was created in Access.
 
hi,
you would have to use the visible property of the list
boxes. have all set to false then reset the visible
property to true depending on which option was selected.
you would also have to use if then else or select case to
determine which list box to light up.
if me.option1 = true then
me.listbox1.visible = true
else
if me.options2 = true then
me.listbox1.visible = true
end if
end if
you would also have to put a sub in each option control to
turn of all the other options if any options is selected
if me.option1 = true then
me.option2 = false
me.option3 = false
'ect
end if
this way, you will have only one option set to true at a
time.
post back if you need more help
 
Back
Top