Passing parameter to report from command button

[foxy]

Hi,

I have a report that diplays info on a single person. It has a parameter of 'Person ID'.

I also have a continuous form which displays a list of people from the database with a command button on each row for each person.

I want to be able to click on the command button on a single row and pass that per_id to the parameter on the report.

I have the following VBA so far:

DoCmd.OpenReport "rptWholePerson", acViewReport, , "[Person ID] = Me.[per_id]"

But when I click the command button I still get prompted for the parameter??

Any suggestions?

Cheers

Foxy

 

[KenHigg]

DoCmd.OpenReport "rptWholePerson", acViewReport, , "[Person ID] = " & Me.[per_id]

???

 

[Rich]

Shouldn't that be Me!

 

[KenHigg]

Shouldn't that be Me!

I suppose so ...

We may never know

 

[foxy]

DoCmd.OpenReport "rptWholePerson", acViewReport, , "[Person ID] = " & Me.[per_id]

???

Nah it's still prompting me for the parameter

????

 

[gregorg]

DoCmd.OpenReport "rptWholePerson", acViewReport, , '"[Person ID]=" & Me.per_id'

??????

person_id = Me.per_id
DoCmd.OpenReport "rptWholePerson", acViewReport, , '"[Person ID] = " & person_id'

??????

Its just getting the right syntax ?

 

[gregorg]

It might be this , quotes, [person ID] = single quote, quotes, & Me.[per_id], quotes, single quote, quotes.

So, DoCmd.OpenReport "rptWholePerson", acViewReport, , "[Person ID] = '" & Me.[per_id]"'"

so its parsed correctly.

gregorg.

 

[gregorg]

DoCmd.OpenReport "rptWholePerson", acViewReport, , "[Person ID] = '" & Me.[per_id]"'"

so if person id is 4

it looks like this to the report

[Person ID] = '4'

 

[foxy]

DoCmd.OpenReport "rptWholePerson", acViewReport, , "[Person ID] = '" & Me.[per_id]"'"

so if person id is 4

it looks like this to the report

[Person ID] = '4'

Hi,

Tried this and its still prompting me for the parameter, its really baffling me why its not working!

 

[gregorg]

Dont know, can you try to msgbox me.per_id ????? or mgsbox "[Person ID] = '" & Me.[per_id]"'"

????

 

[Rich]

"[Person ID] = " & Me![per_id]

 

[marnieg]

Sounds like you may have a parameter associated to your Query on the actual report. You don't need a query parameter on the report since you are passing the parameter in the OpenReport command.

 

[gregorg]

i think rich is right.

 

[gregorg]

question - because the parameter is off the form ?

 

[gregorg]

but the ark floated and the titanic sank