Where condition on reports doesn't work when passing parameter from the forms

[oranmeir]

DoCmd.OpenReport stDocName, acPreview, , "[ORDERID] =
Forms![OrderForm].[ORDERID]"

On access 2003 only the orderid selected on the form shown on the
report. on access 2007, all the records shows on the report. it ignore
the where condition...

Any ideas?

 

[Allen Browne]

Concatenate the value from the from into the WhereCondition string:
DoCmd.OpenReport stDocName, acViewPreview, , _
"[ORDERID] = " & Forms![OrderForm].[ORDERID]

There's a couple of other things that can go wrong here, such as if the
record in the form is not saved, or if the form is at a new record. See:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

 

[oranmeir]

Same problem... anyone?

Concatenate the value from the from into the WhereCondition string:
DoCmd.OpenReport stDocName, acViewPreview, , _
"[ORDERID] = " & Forms![OrderForm].[ORDERID]

There's a couple of other things that can go wrong here, such as if the
record in the form is not saved, or if the form is at a new record. See:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

DoCmd.OpenReport stDocName, acPreview, , "[ORDERID] =
Forms![OrderForm].[ORDERID]"

On access 2003 only the orderid selected on the form shown on the
report. on access 2007, all the records shows on the report. it ignore
the where condition...

 

[Duane Hookom]

Add a text box to the report header with a control source of:
=[Filter]
What does it display?


--
Duane Hookom
MS Access MVP

Same problem... anyone?

Concatenate the value from the from into the WhereCondition string:
DoCmd.OpenReport stDocName, acViewPreview, , _
"[ORDERID] = " & Forms![OrderForm].[ORDERID]

There's a couple of other things that can go wrong here, such as if the
record in the form is not saved, or if the form is at a new record. See:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

DoCmd.OpenReport stDocName, acPreview, , "[ORDERID] =
Forms![OrderForm].[ORDERID]"

On access 2003 only the orderid selected on the form shown on the
report. on access 2007, all the records shows on the report. it ignore
the where condition...

 

[Gina Whipp]

I use this in Access 2003... (I changed the field names to match yours.)
DoCmd.OpenReport stDocName, acPreview, , "[OrderID]=" & OrderID

I do not reference the form.

HTH,
Gina Whipp

Same problem... anyone?

Concatenate the value from the from into the WhereCondition string:
DoCmd.OpenReport stDocName, acViewPreview, , _
"[ORDERID] = " & Forms![OrderForm].[ORDERID]

There's a couple of other things that can go wrong here, such as if the
record in the form is not saved, or if the form is at a new record. See:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

DoCmd.OpenReport stDocName, acPreview, , "[ORDERID] =
Forms![OrderForm].[ORDERID]"

On access 2003 only the orderid selected on the form shown on the
report. on access 2007, all the records shows on the report. it ignore
the where condition...