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
|
|||
|
|||
How to modify query parameters in code?
Somehow your "parameter in an event" doesn't compute. That would
imply a hard coded value. You would do better to hard code the value in the criteria line where you and others would expect to find it. Your report is based on a query. The usual trick is to leave a value in a control on the form that opens the report. On the criteria line you refer back to it putting something like the following in the criteria line: Forms!MyForm!Mycontrol If you're getting an unwelcome prompt you may already have a prompt in square brackets in your criteria line or you may have gone through the "parameter query" helper which could also evoke a prompt. HTH -- -Larry- -- "Everyman" wrote in message ... Could someone explain how I can assign a value to a parameter in an event? What I'm trying to do is get around a prompt for input. I'm hoping that if I assign a value in the report open event, then the prompt won't pop up. I've already removed the param declaration from the associated query, and hardcoded a value, but the prompt is still coming up, so there must be some reference to it that I'm missing. Thank You |
Thread Tools | |
Display Modes | |
|
|