Hi,
I am designing a form with a CommandButton in it. If I click this button it runs another form i.e form 45 (Purchase List) which has the source table as “Purchase Header”. My issue is, when I click the button, the form 45 which opens should be filtered i.e the entries in that should filter based on the Field “Order Date” and the system WORKDATE. Only the entries which have the “Order Date” same as the WORKDATE should be displayed.
How do I go on with this? Can anyone help me…