using a yes/no field to drop-down a sub form

[Guest]

I would like to create a form which contains general information. In the
general info form, there would be a yes/no field (ex: Feedback) that when a
user clicks on it for "yes" it will drop down or open a subform to enter the
feedback information. Is this possible? If so, how would I do this?

 

[kingston via AccessMonster.com]

Use the control's AfterUpdate event. In the procedure, check for the
control's value. If it is "Yes" then open the secondary form or enable the
subform or make the subform visible.

 

[Guest]

Ok...I can understand most things in Access but I am a little confused on
your reply...I guess I need some step-by-step instructions. Sorry

Jamie

 

[kingston via AccessMonster.com]

One way to do this is to not use a subform and open another form. In the
form's design mode, select the Yes/No control and find its After Update event
under the Event tab. Select [Event Procedure] and click on the ... button at
the end of the box.

For the Yes/No control's AfterUpdate event, create a procedure like:

DoCmd.Close acForm, "OtherForm"
If Me.YesNoControl = -1 then
DoCmd.OpenForm "OtherForm"
End If


If you use a subform, use something like this for the AfterUpdate event:

Me.SubFormControl.Enabled = 0
If Me.YesNoControl = -1 then
Me.SubFormControl.Enabled = -1
End If

You could also use the subform's .Visible or .Locked property depending on
what you want to do.

Ok...I can understand most things in Access but I am a little confused on
your reply...I guess I need some step-by-step instructions. Sorry

Jamie

Use the control's AfterUpdate event. In the procedure, check for the
control's value. If it is "Yes" then open the secondary form or enable the

[quoted text clipped - 4 lines]

 

[Guest]

Thanks...this should work. I was playing around with it and figure out that
opening another form would be better. ALso, I guess I should have said that
I understand most "basic" things in Access; for some of the "advanced"
things, I still need some help...that is where these discussions groups come
in. Thanks again!

One way to do this is to not use a subform and open another form. In the
form's design mode, select the Yes/No control and find its After Update event
under the Event tab. Select [Event Procedure] and click on the ... button at
the end of the box.

For the Yes/No control's AfterUpdate event, create a procedure like:

DoCmd.Close acForm, "OtherForm"
If Me.YesNoControl = -1 then
DoCmd.OpenForm "OtherForm"
End If


If you use a subform, use something like this for the AfterUpdate event:

Me.SubFormControl.Enabled = 0
If Me.YesNoControl = -1 then
Me.SubFormControl.Enabled = -1
End If

You could also use the subform's .Visible or .Locked property depending on
what you want to do.

Ok...I can understand most things in Access but I am a little confused on
your reply...I guess I need some step-by-step instructions. Sorry

Jamie

Use the control's AfterUpdate event. In the procedure, check for the
control's value. If it is "Yes" then open the secondary form or enable the

[quoted text clipped - 4 lines]

user clicks on it for "yes" it will drop down or open a subform to enter the
feedback information. Is this possible? If so, how would I do this?

 

[taioldi]

excuse me but can i please get support understanding that part i need it exactly as it is please find the situation below as i explained it and let me know if that is possible:

Table 1: System Inventory


System ID System Name Location Computerized
00001 system A WHS YES
00002 System B MFG NO
00003 System C PCG YES
00004 System D PCG NO
00005 System E PCG NO
00006 System F WHS NO
00007 System G MFG YES
00008 System H MFG NO
00009 System I WHS NO
00010 System J MFG YES


Table 2: Computerized system details

SystemID System Name Software Version Backup
00001 System A 3.10V CD-ROM
00003 System C 2.00V DVD
00007 System G 1.10V FLASH
00010 System J BETA HDD




thats pretty much how i want the final base to be

about the forms i thought of

form with everything and a submit button, event on click, save record + check computerized field (Table1) status IF true, mov system ID to accumilator, mov accumilator to system ID in Table 2, move system name to accumilator, mov accumilator to system name in Table 2 + open forum 2 with the system ID and system name saved