display query creteria on a form and or report

D

Damon Heron

With the form or report in design view, select the properties, record
source, and select the query name as the source. As you add controls,
(textboxes, etc) select the properties of the control and select control
source. You will have a list of the fields in the query. Select the one
you want for that control.

Damon
 
K

KARL DEWEY

In the query design view grid scroll to the field with the criteria.
Highlight the criteria, copy, and scroll the right to a blank field.
Type something like this --
My_Criteria: then paste the copy of the criteria to result in
this ---

My_Criteria: [Enter Status]
 
D

Damon Heron

Sorry, misunderstood your question. You want to show the criteria used on
the form, correct?

Damon
 
Top