record soource & parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to change the record source for two controls
in a report. I want the report to run based on parametrs
entered. e.g. requested by & date.
In design view I can only change the record source for
all controls.

How do i get the report to show parameters for only two
controls before it runs.
 
In your query (upon which the form is based) put something like...

[EnterRequestedBy] under the 'requestedby' field. This will prompt the user
to make an entry, and the records will only display if the records match the
entry.

Under the date field, to get a range, enter something like:

Between [EnterStartDate] and [Enter End Date]


Rick B

I am trying to change the record source for two controls
in a report. I want the report to run based on parametrs
entered. e.g. requested by & date.
In design view I can only change the record source for
all controls.

How do i get the report to show parameters for only two
controls before it runs.
 
Back
Top