List box record to Report

Hello!

In a Form I have 3 combos that they go "filtering" the records that are read
in exactly form in one listbox.
One of the fields IdRecord.
When click in the one list box row (one record), it opens a Report but it
shows all the records of listbox, that they are in query, and not only what
it was selected.

It would like help so that in the Report it only came the selected record
and not all showed.

Thanks in advance.
an

If you open a report by clicking on the list box, presumably you have a
macro or code that uses the OpenReport action. You can use the
WhereCondition in OpenReport to limit the report to just the record in your
form.

For an example, see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

--
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.

"an" wrote in message
...
Hello!

In a Form I have 3 combos that they go "filtering" the records that are
read
in exactly form in one listbox.
One of the fields IdRecord.
When click in the one list box row (one record), it opens a Report but it
shows all the records of listbox, that they are in query, and not only
what
it was selected.

It would like help so that in the Report it only came the selected record
and not all showed.

Thanks in advance.
an

AB,

Thanks for your help.
Now only necessary to exceed a difficulty: As query is the same of the Form,
it repeats the questions that are answered by comboboxes...

Thank you.
an

"Allen Browne" wrote:

If you open a report by clicking on the list box, presumably you have a
macro or code that uses the OpenReport action. You can use the
WhereCondition in OpenReport to limit the report to just the record in your
form.

For an example, see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

--
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.

"an" wrote in message
...
Hello!

In a Form I have 3 combos that they go "filtering" the records that are
read
in exactly form in one listbox.
One of the fields IdRecord.
When click in the one list box row (one record), it opens a Report but it
shows all the records of listbox, that they are in query, and not only
what
it was selected.

It would like help so that in the Report it only came the selected record
and not all showed.

Thanks in advance.
an