View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ina ina is offline
external usenet poster
 
Posts: 120
Default 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 -