Option buttons for subform viewing
in [Tables]
|
From: EBaker on 21 Dec 2009 17:58 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!
|
Pages: 1 Prev: Option buttons for subform viewing Next: design help needed |