Report List and Description

[epoh97 via AccessMonster.com]

Hello all:

I have a form (Access 2003 SP2) that uses a list box to list all the reports
in a table, I want the report descriptions (also in the table) to appear on
the right of the list box. I have tried using the Link Master Fields and Link
Child Fields but it wont display the right description.

Table Schema
ReportList

ReportName,ReportDescription
Canceled Orders,Shows all orders that have been canceled
New Orders,Shows all new orders that have not been processed
Late Orders,Orders that should have shipped six weeks ago
etc....

 

[Marshall Barton]

I have a form (Access 2003 SP2) that uses a list box to list all the reports
in a table, I want the report descriptions (also in the table) to appear on
the right of the list box. I have tried using the Link Master Fields and Link
Child Fields but it wont display the right description.

Table Schema
ReportList

ReportName,ReportDescription
Canceled Orders,Shows all orders that have been canceled
New Orders,Shows all new orders that have not been processed
Late Orders,Orders that should have shipped six weeks ago
etc....

I don't understand the problem. The list box can display
both columns so where else do you want it to be?

If you don't have space on the form or the description is
too long to display entirely in the list box, the use a text
box with an expression like:
=listbox.Column(1)

 

[epoh97 via AccessMonster.com]

I want to display the description beside the listbox (I know that can be
acheived by adding the description to the list box)

I want it to appear like a hard coded description, more or less. When the
user selects the name of the report, they can also see the description in
formatted text beside it.

=============================================

Marshall Barton wrote:
I don't understand the problem. The list box can display
both columns so where else do you want it to be?

If you don't have space on the form or the description is
too long to display entirely in the list box, the use a text
box with an expression like:
=listbox.Column(1)

 

[epoh97 via AccessMonster.com]

If you want a sample of what I am trying to achieve look at this link:

http://office.microsoft.com/en-us/templates/TC010178391033.aspx?CategoryID=CT011366681033


Open Database, Press 'View Reports'

I wanting to add the report description to the right of the list box.

 

[Marshall Barton]

If you want a sample of what I am trying to achieve look at this link:

http://office.microsoft.com/en-us/templates/TC010178391033.aspx?CategoryID=CT011366681033

Open Database, Press 'View Reports'

I wanting to add the report description to the right of the list box.

I don't see a list box, either with or without a description
next to it on any of the 9 templates samples at that link.
There are a few combo boxes, but agian, I don't see a
description next to any of those either.

I've already answered what I understand you're asking for.
Did you try it? If you did, what about it isn't what you
want. If you didn't try it, why not?

 

[epoh97 via AccessMonster.com]

Marshall, I did try it, but it just displayed the same thing in the textbox
that was in the listbox. I changed it to (2) and that didnt work either.

 

[epoh97 via AccessMonster.com]

Thanks Marshall, I changed it back to what you said and it worked. My
apologies, I had changed the listbox to look at another value during my
testing.

 

[Marshall Barton]

That's good news. For a minute there, you had me worried.

 

[epoh97 via AccessMonster.com]

lol

That's good news. For a minute there, you had me worried.

Thanks Marshall, I changed it back to what you said and it worked. My
apologies, I had changed the listbox to look at another value during my

[quoted text clipped - 5 lines]