Item filter in Purchase order

tompynation

How would you set a filter to the Lookup of the Item in the Purchase order subform so that the lookup form would only show the Items who are available with the Vendor selected in the "Buy from Vendor No." in the Purchase header...

This user should also be able to remove this filter from the lookup form so that he sees all items.

I guess i could programmatically set the Lookup form and filter in de the OnLookup trigger of the "No". field in de Purchase subform. But will i then be able to remove the filter so i see all items?

kapamarou

If you set the filter manually, then if you don't use the FILTERGROUP function the user will be able to change the filters...