loading different subforms depoending on the entry in a dropdown f

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

same subform used in two different forms 2
Deny changing value in field, based on values of multiple fields 4
Help with Subform in a subform within main form 1
variable subform values 1
Filtering a subform using multple criteria 2
filter query on combo box in a continuous subform 0
Relationships and subforms issue 1
Speed up Form with 4 Subforms 3

Back
Top