Filter

[daniyalg1]

I have 2 Forms 1. Purchase Orders Form 2. Purchase Order1 Form



Purchase Orders = It is Purchase Order Generation Form
Purchase Orders1 = It is Invoice Generation Form

When I create Invoice ie. Supplier =ABDUL KARIM It should Show Only ABDUL KARIM related Purchase Order Number. Not Others.

For your reference please see attached images.

Please Help

regards

Daniyal

[Bulzie]

In properties of the Invoice form, in the LinkMaster and LinkChild, put PONumber (or whatever you named that field)

Or OnOpen event of the Invoice form do a filter:

Me.Filter = "Country = " & [Forms]![frmPOOrder]![PONumber]
Me.FilterOn = True