Go to Top

How can I add a new criteria to the system?

First, always backup your Access database prior to making any changes. Second, place the frmReportGenerator in design view. The easiest way add a new criteria is to copy an existing one, so if you have data criteria, copy txtStartDate, if its a combo box, copy the ProductID object. If all you need is a regular text field, copy the JobNumber object.

  • You must change your new field name by going into the properties of the new field and changing the Name value under the Other tab.Pick a name that is the same as the field in your table. So if you are going to use the criteria for a report that uses PONumber, than use PONumber as the name. Doing it that way will mean not having to specify a field name every time you add a new report to the system that uses that criteria.
  • Under the tag property of the Other menu, make sure the word Criteria is entered into the field. If the field is a number criteria, use CriteriaN or if it’s a string, use CriteriaS. If it’s anything else just use Criteria in the tag field.
  • If you need to change the datasource of the combo box please see “How can I change the existing criteria data source?”
Was this answer helpful ? Yes / No

About Alex Mielus

Alex is a Web & Access Developer and also the web server admin at IT Impact.
Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.