Hi! I have a form Called "Customer Order" and on which there is a subform called "Order". On the "Order" subform I have a combobox to select values.
This combobox selection must reflect on One Form called "Order Details Subform1".
This "Order Details Subform1" Has one subform, called "Order Details"
"Order Details" has one subform called "frmDetailChecklist". This "frmDetailChecklist" has to change based on the combobox selection to another form which I designed called "frmNetworkChecklist"
The Problem here is "frmDetailChecklist" is linked to the "Order Details" Subform by Child and master fields. As I told u I designed one form called "frmNetworkChecklist", but I didn't link this one to "Order Details" Subform.
I have two values in my combobox.Based on these two values these two forms has two change correspondingly.
Here is the code I wrote:
Private Sub Form_Load() ' this code goes in Order Details Subform1
Select Case Forms![Customer Order]![Order].Work_Type
Case 1 'This represents the column which is bound to combobox
ChecklistTitles.SourceObject = "frmDetailChecklist"
ChecklistTitles.SourceObject = "frmNetworkChecklist"
ChecklistTitles is the subformcontrol for frmDetailChecklist.
With this code I am getting errors like "Object does not support this method or Object"