report rowsource query

[DL]

Hi,
I want to specify the query that will be used in a report by giving options
in a form.
then with a command button the following will happen:
-------------
QRY= "SELECT * FROM registration"

DoCmd.OpenReport "report", acViewPreview, , QRY
-------------
I have simplified the query for this example but it doesn't work with this
either...
Lets say I have only one field to show in my report: personal ID --> pid
I still get #Name?

Can anyone help me put this QRY right so it will work with the OpenReport
command and
setting my QRY as a recordsource(I guess it should be done this way)

Thanks!!!!

[Allen Browne]

The WhereCondition argument of OpenReport is not a full query: just the
WHERE clause.

Taking your example of a file called "pid", and assuming that you want to
use the number in the text box called "pid" on your form, try:

Dim strWhere As String
strWhere = "pid = " & Me.pid
DoCmd.OpenReport "report", acViewPreview, , strWhere

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"DL" <da*******@hotmail.com> wrote in message
news:40*********************@news.wanadoo.nl...

I want to specify the query that will be used in a report by giving options in a form.
then with a command button the following will happen:
-------------
QRY= "SELECT * FROM registration"

DoCmd.OpenReport "report", acViewPreview, , QRY
-------------
I have simplified the query for this example but it doesn't work with this
either...
Lets say I have only one field to show in my report: personal ID --> pid
I still get #Name?

Can anyone help me put this QRY right so it will work with the OpenReport
command and
setting my QRY as a recordsource(I guess it should be done this way)

[Saintor]

QRY have to be a filter, not a row source like

"personalId='"& me.pid & "'"

in your case if pid is a text.
"DL" <da*******@hotmail.com> wrote in message
news:40*********************@news.wanadoo.nl...

Hi,
I want to specify the query that will be used in a report by giving options in a form.
then with a command button the following will happen:
-------------
QRY= "SELECT * FROM registration"

DoCmd.OpenReport "report", acViewPreview, , QRY
-------------
I have simplified the query for this example but it doesn't work with this
either...
Lets say I have only one field to show in my report: personal ID --> pid
I still get #Name?

Can anyone help me put this QRY right so it will work with the OpenReport
command and
setting my QRY as a recordsource(I guess it should be done this way)

Thanks!!!!