List box record to Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

an - 22 Jan 2006 01:38 GMT

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

Reply to this Message

Allen Browne - 22 Jan 2006 04:01 GMT

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

Signature

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.

> Hello!
>
[quoted text clipped - 12 lines]
> Thanks in advance.
> an

Reply to this Message

an - 22 Jan 2006 18:59 GMT

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

> 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
[quoted text clipped - 22 lines]
> > Thanks in advance.
> > an

Reply to this Message