loading different subforms depoending on the entry in a dropdown f

A

arnoldarmy

I have a field which identifies from a drop down list 4 different types of
transactions - cash expenditure/ cheque expenditure/ transfer etc
What would like to happen is that on choosing one of these entries the
subform changes to a specific subform for each type of entry.

Is this possible - if so could you point me in the right direction?

thanks
 
S

Steve Schapel

Arnold,

You can toggle the Source Object property of the subform control,
according to the selection in the combobox. Code on the After Update
event of the combobox would be something like this...

Select Case Me.TransactionType
Case "cash expenditure"
Me.SubformName.SourceObject = "YourCashForm"
Case "cheque expenditure"
Me.SubformName.SourceObject = "YourChequeForm"
... etc
End Select
 
Top