Text box on group footer is linked to a field but is pulling in the wrong column

[jkj115]

Hi Everyone -

I have a report that has a Footer - in the footer I am subtotaling some information and I want a textbox in the footer to say "Summary For" and then insert the current grouping..So the report is grouped by "Color" and one of the statuses is "Blue". The text box should read "Summary For Blue".


The problem is the report is pulling in the ID for the Blue field.

The way the data is set up is there are two tables. The first table has all of the main information and then within that table you can select the color, which is based on a separate table.



Thanks!

[ItsMe]

In the control's properties, look at the "Data" tab and adjust the "Control Source" to the desired value. This is the property field that will determine what is displayed in your control.

[jkj115]

There are two tables. In the main table, there is a combo box to select the color. The color table has two columns, an ID and a Color. The Color is what is pulled into the main table. In the report (which is linked to the main table), I select the Color control, but somehow it pulls in the ID from the color table instead of color name from the main table.

[ItsMe]

Sounds like you have a lookup field in a table. You have a report and want the lookup field to display the relative value of column 2 of the lookup field. Instead, your control on the form is displaying the ID of the lookup field, column 1. Sounds like the bound column of your lookup field is column 1.

You will have to reference column 2 in your lookup field from the control's properties on the report.

I am not sure how to do this. I do not use lookup fields. You can try

FieldName.Column(2)

I tried searching the web but could not find any reference

[jkj115]

Thanks - that is helpful. I was able to figure it out by playing with those reference columns in the data table!

[ItsMe]

Good deal! I wasn't sure how to go about it.....