Hi,
I've a main form with a combobox and a subform. The subform is based on a query.
The input from the combobox filters the outcome of the subform, via the AfterUpdate event:
With [Forms]![frmKundstatistik]![subfrmAnbudPerKund].Form
.Filter = "[KundID] = " & Me.cboValdKund
.FilterOn = True
End With
Above works perfectly, but when I include the mainform in a Navigation form (std one, with both horizontal and vertical tabs) it doesn't work. I assumed it would be so due to previous experience. The question is; How do I get it to work in the Navigation form?
I) Can I use some sort of SQL string in order to requery the subform inside the mainform which in turn has been moved inside the Navigationform?
II) Can I rewrite above expression in some manner?
Rgds
I've a main form with a combobox and a subform. The subform is based on a query.
The input from the combobox filters the outcome of the subform, via the AfterUpdate event:
With [Forms]![frmKundstatistik]![subfrmAnbudPerKund].Form
.Filter = "[KundID] = " & Me.cboValdKund
.FilterOn = True
End With
Above works perfectly, but when I include the mainform in a Navigation form (std one, with both horizontal and vertical tabs) it doesn't work. I assumed it would be so due to previous experience. The question is; How do I get it to work in the Navigation form?
I) Can I use some sort of SQL string in order to requery the subform inside the mainform which in turn has been moved inside the Navigationform?
II) Can I rewrite above expression in some manner?
Rgds