If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
record soource & parameters
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. |
#2
|
|||
|
|||
record soource & parameters
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 wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Button to print current record only | Fatz | Using Forms | 6 | June 17th, 2004 01:58 PM |
Problems with record locking | Ronny Salomonsen | General Discussion | 0 | June 14th, 2004 09:37 AM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |
Form Does Not Go To New Record | Steve | New Users | 1 | May 12th, 2004 03:15 AM |
Avoid Creating A Duplicate Record | Mark | New Users | 4 | May 11th, 2004 01:52 AM |