Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Access Queries and JET SQL FAQ

Good Practices

Why not use Parameter Prompts by dhookom
Posted: 2 Nov 07 (Edited 2 Oct 08)

Parameter prompts in the criteria of queries is fairly common but have too many limitations. IMHO, users should never be subjected to them.
  • They don't allow defaults
  • They don't allow picking from a list
  • They don't allow seeing multiple values at once
  • They aren't easily re-used
  • You can't check their integrity
  • You can't limit one based on the value of another
  • They don't support input masks or formats
  • Their values can't be displayed in a report that returns no records
  • They are annoying like pop-ups
  • They are difficult to query with a foreign key value that has no meaning
  • You rarely if ever find a parameter prompt type interface in any decent software application
Using values from controls on forms avoid the above limitations. Rather than SQL like


SELECT tblSales.*
FROM tblSales
WHERE SaleDate Between [Enter Start Date] and [Enter End Date]
Try build professional applications that use


SELECT tblSales.*
FROM tblSales
WHERE SaleDate Between Forms!frmDates![txStartDate] and Forms!frmDates![txtEndDate]

Back to Microsoft: Access Queries and JET SQL FAQ Index
Back to Microsoft: Access Queries and JET SQL Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close