Filter a combobox in a subform with another combobox from main form

[jjake]

Hi,

I have a combo box on a subform that i would like to filter the results from the choice made on the main form.

I have done this successfully with 2 combo boxes on a main form using the query [Forms]![frmOrder]![PurchaseType].

But the subform doesn't seem to work the same. My subform name is [frmOrderline]

Thanks.

 

[Ranman256]

the filter action would take place in the sub form and affect that query. (not the master form)
in sub form:

sub cboFltr_AFterupdate()
  me.filter = "[field]=" & cboFltr
  me.filterOn = true

 

[jjake]

I tried this but maybe I am doing something wrong.

I am trying to filter combo box [CostCenter] on [frmorderline] with the selection made in combo box [Purchasetype] on [frmorder]

I put this into [frmorderline]

Sub CostCenter_AFterupdate()
  Me.Filter = "[PurchaseType]=" & CostCenter
  Me.FilterOn = True
End Sub

 

[jjake]

Any other input on this or can someone see what I am doing wrong above?

Thanks!