User Defined Constraints

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am in the initial stages of structuring an Access
database, and wanted to know how you can construct a query
that will ask the user for the constraints. I know this
may be extremely vague, but for example, if i have a list
of names with corresponding values for each name, and I
want to be able to run a query where the user can run a
query and be prompted to enter a name, and then have the
query generate results based off of that name. General
syntax would help out immensely. Thanks
 
Sounds like you want to run a parameter query. Try looking that up in the
online help.

Small example:
Field: LastName
Table: YourTable
Criteria: [Find what last name?]

This will open a dialog box with the text between the brackets and a place for
the user to enter data to be matched.
 
Back
Top