combo box item not being displayed in report

[mstekkie]

hello,

hopefully someone can help me with this.

i've got a combo box that has three fields: primary key, occupation name, and occupation code.

i also have a few reports that require the occupation name to be displayed. problem is, that instead of showing the occupation name, it only shows the primary key. how do i fix this?

any help will be appreciated. thank you in advance!

ms.tekkie

 

[coco86]

I've never used a combobox on a report before but try this:

Change the properties of the combo box so that the column count is 3

Adjust the column widths properties to something like:0";2";2" (the widths of the second two columns don't matter but the first one has to be 0

 

[mstekkie]

hi coco86,

sorry. i guess i'm not explaining myself properly. the combo box for the occupation is on a form. from that form i've got a button to open a report. and it's on the report that it shows the primary key.

i've changed the column widths on the form to only display the name and the code. but i'm not too sure how to transfer that info to the report.

i'm sorry if that's not very clear. hopefully you can still help me.

thank you!

ms.tekkie

 

[coco86]

Ok, then...

Is the occupation field part of the table or query that you're using for the report? If it is, you can just change the control source for the report field to the occupation field.

If it's not, modify your query.

I hope I'm understanding the problem correctly.

 

[mstekkie]

thanks for the quick response!

the occupation field is a part of the query that creates the report. even in the query, it only shows the primary key. is it possible to change the column widths here to display only the occ. name?

 

[coco86]

Is the field a lookup field? If it is, then yes, I think you can change the width but if I recall correctly, the one time I tried to do that, there were "issues" and it was more trouble than it was worth. (sorry, I don't remember the details)

A better choice might be to create a join between the table your report is based on and the table that has the occupation names in it. Then add the name field from the second table instead of the key from the first table