>I have created a view that asks the user to enter a Fiscal Year, e.g.
>
>prcFiscalYear LIKE ?'Fiscal Year Surrounded by % (e.g. %98%)'
>
>The view when used comes up and asks the appropriate question, but my user does not want to enter the %, they just wish to enter the 98. So how can I have a parameter that comes up with a question, but after the user enters the fiscal year slaps a '%' on the front and back of what they entered. Any help would be appreciated. Or send me in another direction on getting user input in a parameterized view.
The parameterized view only 'pops' the window if no variable with the appropriate name is in scope; if you pop your own dialog asking for input and build the appropriate string just before the use (and ensure that the variable is in scope or reinitialized on each REQUERY()), the user will never see the default dialog.