Use Data Forms

You probably do not want users to add data in a spreadsheet-based, data-driven DSS, but a data form can still be useful in the design of the system. A data form can assist a user in finding records of interest. From a cell in a data list, a user can click on Data on the menu bar and then click Form and Criteria. The data form changes so all fields are blank and "Criteria" appears in the upper-right corner. Type a value in a field and then click on Find Next. You may want to record a Macro that attaches to a "Search" button. With a macro users of the DSS do not need to use the menu commands.

appeared in DSS News 09/15/02