listbox connection to subform
I’m trying to specify a link box as the linkMasterField to my subform. Could someone tell me if below is on the right track b/c it is giving me some problems, essentially listbox value is meant to filter (further) the subform. Below code applies to the list box as it appears on the main form.
Private Sub lstType_AfterUpdate()
'establish linkMasterFields & linkChildFields in the subform...
Me![NewQuery subform].LinkMasterFields = Me![lstType].value
Me![NewQuery subform].LinkChildFields = Me![NewQuery subform].Form![PromotionType]
End Sub
I’m trying to specify a link box as the linkMasterField to my subform. Could someone tell me if below is on the right track b/c it is giving me some problems, essentially listbox value is meant to filter (further) the subform. Below code applies to the list box as it appears on the main form.
Private Sub lstType_AfterUpdate()
'establish linkMasterFields & linkChildFields in the subform...
Me![NewQuery subform].LinkMasterFields = Me![lstType].value
Me![NewQuery subform].LinkChildFields = Me![NewQuery subform].Form![PromotionType]
End Sub
