doCmd not working

[rry2k]

Hi,
I have a form that will allow the user to select different options for different views in a report. I'm trying to use the where parameter in this doCmd statement. I took this out of a parm query that I wrote that does work outside the macro. When I run it from the form, I get an object not found.

Thanks for the help..Russ
Private Sub Option0_Click()
DoCmd.OpenReport "presentation", acViewPreview, , Presentation01.Candidate1 Like "*" & [Type a candidate:] & "*"

 

[parkfairfax]

not sure I can solve your problem, but I have worked a little with statements like these. Try using ' ' or ` ` around your parameters.

 

[rry2k]

thanks that didn't work.

 

[neilkonitzer]

The way that I pass values to reports where the queries contain input parameters is to pass the value using the SendKeys function prior to calling the report. Of course, you'd need to make the query accept the filter as a parameter.

Neil Konitzer, President
Freisoft

http://www.freisoft.com

 

[rry2k]

can you elaborate on that?
Thanks..R

 

[datawise]

Try this - strings in where conditions must have quotes around them, whereas numbers don't so you could have

"[CandidateID] = " & me.candidateid

but

"[Candidatename] = " & chr(39) & me.candidatename & chr(39)

chr(39) is a single quote - I find it easier to do it this way so that I don't have to nest quotes

Private Sub Option0_Click()
DoCmd.OpenReport "presentation", acViewPreview, , "Presentation01.Candidate1 Like " & chr(39) & "*" & [Type a candidate:] & "*" & chr(39)