E
EBaker
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!
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!