Anyone know how I can bring up the table filter dialog that you get when you press Ctrl+F7 from my code.
A client would like to be able to pick an item from the Sales Header table, but at the time is unsure which one or how to filter it. They can filter it on any field existing in the sales header table. I can bring up the Sales Header table and so far all I can do is try to replicate the CTRL+F7 code which seems a bit like too much duplication. I would then like to bring up the Filter dialog instead to allow them filter their selection.
The Table Filter Form you get with Navision by pressing (CTRL+F7) is exactly what I want, since it allows them to add as many of the fields and apply it. But so far I've not been able to find anything to say how to call up this filter automatically.
Is their a command I can run from my code to bring up this Table Filter without requiring the user to have to press the CTRL+F7?
Thanks
0
Comments
IF ISCLEAR(WShell) THEN IF NOT CREATE(WShell) THEN EXIT;
WShell.SendKeys('^{F7}');
And have WShell declared as a variable of Automation of type 'Windows Script Host Object Model'.WshShell.