option boxes

  • Thread starter Thread starter Vanessa
  • Start date Start date
V

Vanessa

hi,
i've got an option box on a main form. There are two
choices : either 1 or 2.

Depending upon which option a user makes, one of two
subforms should become visible fo ra user to be able to
fill in.

Anyone know where I can find a refernce for doing this?

V-
 
Vanessa said:
i've got an option box on a main form. There are two
choices : either 1 or 2.

Depending upon which option a user makes, one of two
subforms should become visible fo ra user to be able to
fill in.

Anyone know where I can find a refernce for doing this?
Click to expand...


It's all in Help, if you could figure out how to piece it
all together :-(

You should probably use the option group's AfterUpdate event
to execute code like this:

Me.subformcontrol1.Visible = (optiongroup = 1)
Me.subformcontrol2.Visible = (optiongroup = 2)
 
Set the after_update event of the option group to
something like the following:

if {optiongroup}.value = 1 then
me!subform1.visible = true
me!subform2.visible = false
else
me!subform1.visible = false
me!subform2.visible = true
endif

Hope this helps!

- Scott
 
Back
Top