Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
osupratt
Posting Yak Master
238 Posts |
 Posted - 2008-09-05 : 12:07:42
|
| I have a report I'm doing that is collecting data from a query. I have 'date in' and 'date out' parameters. I also have a form I created with a drop down getting data from a table. The query that the report dependent upon has the BETWEEN [date in] AND [date out]. When run it pulls back correct data set. I have a field called 'location' which my form which looks like a dialog box is dependent upon. When I run these three parameters on the report the 'date in' window pops up, the 'date out' window pops up, but then there is a parameter window which has form!locationselect!combo1 on it that pops up instead of the form I created for this. I'm new to this and have looked throughout discussions for an answer. Could anyone point me in the right direction? It would be greatly appreciated. Thanks. |
|
|
georgev
Posting Yak Master
122 Posts |
Posted - 2008-09-09 : 12:12:56
|
Have you tried using[CODE]Forms!locationselect.combo1[/CODE]Note the s on forms
George |
 |
|
|
|
|
|
multiple report parameters (one drop down menu)