Hi! I’m trying to figure out if it is possible to disallow filtering on a specific bound form. The form in question is one of several in a “wizard” designed to guide user through a process. All forms are based on same table and pass the current record in the table through SETRECORD. Thank you very much, Jurica
Hi Perhaps this thread can help you: http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=6100 bye André
Thank you for your help. Actually, I managed to whip up something that works (for the moment) : In the code on Form1 for opening Form2: Form2.SETRECORD(Rec); On Form2: SaveTableView = No (prevents form from saving filters when filter creates empty set - that can mess up the form) Allow Insert, Modify, Delete = No; (prevents F3/F4) OnOpenForm (create filtergroup and save the primary key in variable) FILTERGROUP(10); Rec.SETFILTER(“No.”, Rec.“No.”); RecKey:=Rec.“No.”; FILTERGROUP(0); OnAfterGetRecord IF Rec.“No.” <> xRec.“No.” THEN BEGIN Rec.RESET; Rec.GET(RecKey); END; This works fine when user tries to filter to any value that exists in table; but when filter creates empty result set, OnAfterGetRecord doesn’t get called, and all controls get disabled until filter is removed. This is a kind of solution, but I keep hoping there is something else I can do. Thank you, Jurica