If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|