Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass value to form to subform to subform
Hello,
I have a form (FRM_MAIN) which contains different SubForms (FRM_QUESTIONNER) and these subforms contain others subforms (as FRMSUB1, FRMSUB2, FRMSUB3 ... How can I pass along values to the subforms? I have a Main sub that englobes all subforms. FRM_MAIN (record source select * from Survey) inside this sub I have: FRM_SELECT (a list from which I choose a person -- here a have a error record source select * from candidate) and FRM_QUESTION (Where i have all question) in FRM_QUESTION (record source select * from Survey) I Have FRMSUB1, FRMSUB2, ... (question by category) I would like to create a survey, and the answers for each survey is handed over along the form. table Survey (S_ID, person_Id, date, A1, A2, A3 ... An) Any suggestions would be greatly appreciated. Thanks. Ina |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass value to form to subform to subform
A form is basically a Class module with some predefined methods/events etc.
As such you can add your own properties and methods as you would a normal Class module, shown here as a Public variable for brevity. <FRM_SELECT code Public PersonName As String Public Function DoSomething (Msg as string) as long msgbox Msg end function </FRM_SELECT code <FRM_MAIN code with FRM_SELECT .PersonName="Your Result" .DoSomething .PersonName end with </FRM_MAIN code NickHK "ina" wrote in message oups.com... Hello, I have a form (FRM_MAIN) which contains different SubForms (FRM_QUESTIONNER) and these subforms contain others subforms (as FRMSUB1, FRMSUB2, FRMSUB3 ... How can I pass along values to the subforms? I have a Main sub that englobes all subforms. FRM_MAIN (record source select * from Survey) inside this sub I have: FRM_SELECT (a list from which I choose a person -- here a have a error record source select * from candidate) and FRM_QUESTION (Where i have all question) in FRM_QUESTION (record source select * from Survey) I Have FRMSUB1, FRMSUB2, ... (question by category) I would like to create a survey, and the answers for each survey is handed over along the form. table Survey (S_ID, person_Id, date, A1, A2, A3 ... An) Any suggestions would be greatly appreciated. Thanks. Ina |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass value to form to subform to subform
Hello Nick thanks for this information. I will follow this track; thanks a lot Ina On Jan 30, 10:41 am, "NickHK" wrote: A form is basically a Class module with some predefined methods/events etc. As such you can add your own properties and methods as you would a normal Class module, shown here as a Public variable for brevity. <FRM_SELECT code Public PersonName As String Public Function DoSomething (Msg as string) as long msgbox Msg end function </FRM_SELECT code <FRM_MAIN code with FRM_SELECT .PersonName="Your Result" .DoSomething .PersonName end with </FRM_MAIN code NickHK "ina" wrote in ooglegroups.com... Hello, I have a form (FRM_MAIN) which contains different SubForms (FRM_QUESTIONNER) and these subforms contain others subforms (as FRMSUB1, FRMSUB2, FRMSUB3 ... How can I pass along values to the subforms? I have a Main sub that englobes all subforms. FRM_MAIN (record source select * from Survey) inside this sub I have: FRM_SELECT (a list from which I choose a person -- here a have a error record source select * from candidate) and FRM_QUESTION (Where i have all question) in FRM_QUESTION (record source select * from Survey) I Have FRMSUB1, FRMSUB2, ... (question by category) I would like to create a survey, and the answers for each survey is handed over along the form. table Survey (S_ID, person_Id, date, A1, A2, A3 ... An) Any suggestions would be greatly appreciated. Thanks. Ina- Hide quoted text -- Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subform not refreshing... | Excel Worksheet Functions | |||
form/subform with buttons | Excel Worksheet Functions | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
Using one subform to control another subform | Excel Programming | |||
Transparent subform | Excel Programming |