Create Forms Criteria on the fly

Submitted by: 
Visitors have accessed this post 8925 times.

Create criteria for forms in real time, as needed.

An Instruction form will open when the project opens.

The system was written using MS Access 2010

Default file format is Access 2003


1. Create Form

2. Enter each form field's data type into the field's Tag Property

3. Save form’s information using the frmMaintainForms form

4. Select the form from the frmFormsMenu

5. The criteria form frmFormCriteria will appear. Enter your criteria and run the form.

6. This has NOT been tested with multipage forms.

Zip file includes Access 2003 and Access 2007-2010 versions

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.


send all the forms

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.