Filter subform by mainform Combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

diaare - 02 May 2007 16:58 GMT

I have a main form set up with two cascading combo boxes in the header
section of the form; cboBaseComm and cbo SecComm. cboSecComm filters
dependent on cboBaseComm. (this filter works fine)

In the details section of the form I have a subform that gives vendor
commodity information. I would like this subform to filter based on the
SecComm chosen in the combo box in the main form.

The main form and sub form are linked by SecCommID. I thought I understood
how to create filters based on controls within a form, but it seems I either
get all of the detail info, or none.

Any ideas on how to troubleshoot this?

Thanks,

Reply to this Message

Maurice - 02 May 2007 18:58 GMT

You could try using the after update from the combo:

Mainform!subform!filter=me.combobox
Mainform!subform!filteron=true

Or you could set a reference in the query from the subform

Maurice

> I have a main form set up with two cascading combo boxes in the header
> section of the form; cboBaseComm and cbo SecComm. cboSecComm filters
[quoted text clipped - 11 lines]
>
> Thanks,

Reply to this Message

diaare - 02 May 2007 19:08 GMT

In the subform Query I have the criteria for the SecCommID set as
forms!mainform!cboSecComm.
But this is turning up zero results.

In the subform After Update I have Me.cboSecComm.Requery

> You could try using the after update from the combo:
>
[quoted text clipped - 20 lines]
> >
> > Thanks,

Reply to this Message