Showing listbox values in msgbox

[gazsharpe101]

Hi, I have got 4 separate listboxes on a report and dependant on the content of the report, I wish to display a message box to inform the user of data inaccuracies that are appearing on the report. All I want it to contain is the contents of the 4 list boxes (which as I have said are filled with the correct criteria) next to each other with a message above it. I'm not sure if this can be done by combining the 4 list boxes into a combo box or what I have no idea.

Thanks for your help.
Gareth.

[gazsharpe101]

Hi again, I have got 4 separate listboxes on a report and dependant on the content of the report, I wish to display a message box to inform the user of data inaccuracies that are appearing on the report.

Basically, when the report is loaded, it runs a query and fills the listboxes if certain criterion are met. So, what I want is if the lists get filled then to message box the user with the contents of the 4 list boxes (which as I have said are filled with the correct criteria) next to each other with a message above it. I'm not sure if this can be done by combining the 4 list boxes into a combo box or what I have no idea.

Thanks for your help.
Gareth.

[nico5038]

I can't get a clear view on what you want to achieve.
When data isn't accurate, you need to produce an error report, but perhaps by telling what the users need to do in laymans terms will help....

Nic;o)

[gazsharpe101]

Hi, thanks for your reply. I will try and explain what I am trying to achieve and hopefully you will be able to help me:

What happens is, the user runs a report that is based on a parameterised query. When they run this report, they have to input a parameter which obviously defines what the query returns and hence what the report will show. With the way the report works, it is possible that there may be slight inaccuracies with what is displayed on the report, but this is due to information on the database being incorrect. So, what I want to happen, is when the report is run, a message box appears saying if the figures on the report don't quite add up then it is due to an error on the database and that the user can still see the report but if they want it to be 100% accurate then they need to correct it themselves because I am not in a position to make any assumptions on their behalf.

I have 4 lists in the report header (although it doesn't matter where they are really), and these all get filled using SQL statements which are all variants of the query on which the report is based (so in essence it runs the query again but filters out information based on certain values - the information that is filtered out are the database inaccuracies).

So I want a box to show up and saying something like "please be aware that for the following cases, some information in relation to what is being displayed on this report is incorrect, this will need to be corrected to ensure 100% accuracy on this report".

I hope this helps to explain a little bit more about what I want.

Thanks again for your help.
Gareth.

[nico5038]

Hmm, I see you're suffering from poor database design.
In a "good" database no errors will be present as they are refused when entering the data.
In your case there are two options:
1) Produce the report only based on correct data and create a separate error report.
2) Produce the incorrect report and warn the user.

Looks like you're working with option 2 and want to anticipate for the fact that the report can be accurate or not.
In this situation I would divide the report into 2 sections:
1) Data with error(s)
2) Correct data
That way the user gets the message printed on the report. Triggering errormessages from the creation of a report isn't really userfriendly.
When you can determine that a report contains incorrect data, it would be preferable to inform the user on the "frmReport" with the [Print] button and the required parameter fiolds.

Getting the idea ?

Nic;o)