Access 97: Display a non-Key Column in a report

[Guest_imported]

Me again...

Trying to make a report display a non-Key column (Name).

Currently, my Text Box will give the 1st Colum of my control source (IDNumber) when what I need to show is a name from teh next column of the Control Source Table.

Anyone have any suggestions? Thanks in advance!

Hayle

 

[GGleason]

Hayle,

You could make a query with just the column you need to display. For example, let's say you had a table called tblData and the first two columns were ID and LastName. I would use a combo box instead of a text box and in the properties Data tab, I would set set the Row Source to the following syntax:

SELECT tblData.LastName from tblData;

The user could then pick what he wanted from the drop down list.

HTH,
GGleason

 

[Guest_imported]

I had a problem with Access 2000 that sounds similar to yours. Instead of linking to a table for the list of computer models I chose to use the "Row Source" property in the table and set it to something like this: [1;"E-3400";2;"E-4200"] This worked great till I tried to create a report and it saved me the trouble of creating a separate table just to list the half dozen PC models we have.

I tried everything I could think of but no mater what I did the report would always show the numbers instead of the computer model names. I finally gave up and created the table and linked it to the original table. Made proper adjustments to both the forms and reports that used the table and now everything is working correctly.

I hope this helps in some way.