Force the "Parameter Entry Window" to Display. 1

[xhonzi]

I had a report that refered to a non existant column so that when the report was opened it prompted the user with the "Paramater Entry Window" for a string to search on and all was well.

Now, I have reappropriated the report to use for more than just that purpose so I removed the references to the non existant column. What I want to do now is use docmd.OpenReport with the "where" statement to essentially do the same thing. I used:

docmd.OpenReport GenericReport,,"problem like '*[SearchString]*'"

(I did test this with an actual string in place of the non existant column name, and it worked fine)

Anyways, I kinda hoped this would spawn the entry window like when it's coded into the report itself, but as you all probably know: it didn't. All I got was "cannot find field "|" as blah blah blah" So, I know I can make my own little pop-up forms, but since I'll be doing a lot of these, I was hoping that I could just force the Parameter Entry to display somehow using VBA.

Any guesses?

Xhonzi

 

[PHV]

You may try something like this:

DoCmd.OpenReport GenericReport, , , "problem Like '*' & InputBox("SearchString", "Parameter window") & "*'"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[xhonzi]

Will try, thanks!

 

[xhonzi]

Yeah, that's a good option. Any way to define the size? It's really big...

Thanks again,
Xhonzi