View Single Post
  #1  
Old December 21st, 2009, 10:58 PM posted to microsoft.public.access.tablesdbdesign
EBaker[_2_]
external usenet poster
 
Posts: 2
Default Option buttons for subform viewing

Need some guidence on figuring this out PLEASE!
subforms and forms related by "mainIDPK" .
The following code is in the subforms 'Forms!Form1.mainIDPK' to link the
child fields
Form1 Option group named "actionpanel"
The following options available:

Action Panel label Name Numerical value
MMRB OptMMRB (1)
FFD OptFFD (7)
MEB OptMEB (3)
PDES OptPDES (5)
PEB OptPEB (4)
Closed OptClosed (6)

Subforms:

frmBlank
frmMMRB
frmFFD
frmMEB
frmPDES
frmPEB
frmClosed

Common fields between Form1 and the subforms is "mainIDPK"

The subforms are set to visible No in the subform properties I have them
'stacked' on Form1.

What I want to do is this:
If form1 opens and "MMRB" is already selected, it makes "frmMMRB" visible.
(If there is a '0' in the actIDFK field, "frmBlank' covers al lthe other
subforms)
If I select "FFD" in the actionpanel, I want "frmFFD" to become visible (and
frmMMRB become 'invisible'-but since the forms are stacked, the frmMMRB would
be hidden anyway)

I have been looking at these forums for almost a month trying to get some
clue as to how this could work, bu have been unsuccessful. ANY help
regarding properties, syntax, or how I can make this work is appreciated in
advance!