frmModuleExcel-PR-B05
Put the form criteria box on a light gray background with black letters
Use stored Procedure-Need a table that captures the history of the
prior selection criteria and allow the user to assign it a 30 character
name. This info can be recalled to re-run a report.
If the user doesn't give it a name, Put in
frmModule-Excel-PR-B05-DATE-Time where IN stands for the module, B05 is
the sequence of the button. tblSelectionCriteria-History has been
added for this purpose.
Detail Level drop down box based on tblDetailLevel
Sort by based on tblSortBy
Additional Filter, drop down box based on the User-Defined Fields
PR_Field01 through PR_Field10
Customer ID List box based on PRMSD field PR_NUM
AR Code list box based on PRMSD field PR_CODE
Customer Name box based on PRMSD field PR_NAME
Date Range-Last Sale no lookup based on tblDateRange
Date-Last Sale no lookup based on PR_HIRE
All List and DropDown boxes are to have at least 2 fields |
