Help with report issue

[associates]

Hi,

I was wondering if anyone might be able to help me here.

I have a form that has a listbox that has 3 columns showing up a list of project outline
for example
ID Description Structure
AMO01 Operations and Optimisation P
AMO02 Planned Maintenance P
ECO01 Operations and Optimisation AMO01
ECO02 Planned Maintenance AMO02


When user double-clicks on the AMO01 from the listbox, a report shows up the content of AMO01. If the user
double-clicks on the ECO01, the report should show the content of it. Since It has no data, i expect the
report to show error everywhere.

Then, i was asked to do it this way in order not to getting those error report. That is if ECO01 is selected
, then the report shows the content of AMO01 since they both have the same description.

My question is how do i tell the report to do that? is there an easy way to do this?

Sorry, it sounds pretty easy but i couldn't get it to work

Thank you in advance

 

[Adeptus]

Have the Description as the listbox's Value field, and the report's filter criteria

 

[associates]

Hi Adeptus,

Thank you for your reply.

> Have the Description as the listbox's Value field, and the report's filter criteria

Sorry i'm a bit slow to catch that. Are you saying to have the description as the listbox's bound column. please correct me if i'm wrong. But i'm not sure how i get around this problem with report.

At the moment, there is no code for the report except for

docmd.maximize in the open_report sub

In the report, it shows roughly as follows
in case if AMO01 is selected,

AMO01 - Operations and Optimisation
- water main
- issue outstanding
...

in case if ECO01 selected,
ECO01 - Operations and Optimisation
- water main
- issue outstanding
...

The content of the report for AMO01 is similar to that of ECO01 except that the title of the page header is different according to the ID.

I know that i can use the On NoData event, but i was asked not to do that.

I was wondering if you could help me with this.

Thank you in advance

 

[Adeptus]

> Have the Description as the listbox's Value field, and the report's filter criteria

Sorry i'm a bit slow to catch that. Are you saying to have the description as the listbox's bound column.

Yes that's what I meant

The content of the report for AMO01 is similar to that of ECO01 except that the title of the page header is different according to the ID.

Different header? hmm OK well my idea won't work then...
I don't think I understand the problem well enough. Anyone else care to jump in with suggestions?

 

[associates]

Hi Adeptus,

It works well with the description.

AMO01 Operations and Optimisation P
AMO02 Planned Maintenance P
ECO01 Operations and Optimisation AMO01
ECO02 Planned Maintenance AMO02

When i selected ECO01 from the listbox, the report shows the content of AMO01. But then, how do i keep the ECO01 in the report?

From the example shown below
AMO01 - Operations and Optimisation
- water main
- issue outstanding
...

in case if ECO01 selected,
ECO01 - Operations and Optimisation
- water main
- issue outstanding
...

At the moment, this is what i get when selected ECO01
AMO01 - Operations and Optimisation
- water main
- issue outstanding
...

How do i make the report to show ECO01 that's selected by the user while showing the content of AMO01. So from the user point of view, they wouldn't know if the content is actually from AMO01 because in the report, it says
ECO01 instead of AMO01

We're getting there.

Thank you in advance