A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Option buttons for subform viewing



 
 
Thread Tools Display Modes
  #1  
Old December 21st, 2009, 11: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!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.