ServerFilter on SubForm

D

Dickie

I have a subform which is a list of line details. I need to apply a new
serverfilter to this subform from a button on the main form.

Example, I click the button List All Lines.
It makes the subform visible and then applies the server filter which uses
the bound field on both forms.

Any help would be useful.

I have used the following code but it does not work.
Currform is set to screen.activeform and PO_Hdr_Nbr is a variable containing
the PO Hdr

Currform.[Purchase_Order_Detail].[Form].ServerFilter = "[PO_Nbr] = " &
PO_Hdr_Nbr
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top