Don't know what to call it :S

[XXD]

I have created a report where a textfield shows text of what have been choosen on my form:

=Forms!Start!cbxList

When I preview the report then the value of my combobox, that i have choosen , shows.
The combobox have 2 columns but only the second column is "visible", which it has to be. So when I choose something on my combox i see the second column but the value is on the first column.
Now on my report I need to have the value, but not from column 1 but 2.
Any Idea of how to do this without changing properties from my combobox?

XXD

 

[pbaldy]

Presuming you have a "normal" design, you base your report on a query that includes both tables, joined on that key field. That enables you to include the second column in the report.

 

[XXD]

No. I have one table with two fields; List ID and List name.
My combo box gets its value from the table. But when you press the combo box doesnt the both fields, which the table have, show. Only "List name" shows, because the otherone is hidden. So when i choose any "List name" it gets the value of the "List ID", which is right. But when I type on my report that it should get and show the value of the combo box i dont whant the "List ID" to be showen but the "List name".

Can i write something like this?:

=Forms!Start!cbxList.Value.column2

 

[pbaldy]

Is your report based on this table or some other one? You can refer to the column, but that would only be practical if the report was for that one record only.

 

[XXD]

Its based on the combo box and the combo box is based on the table. How can i refer to the column?

 

[pbaldy]

My first answer is likely the correct one, but:

Forms!FormName.ComboName.Column(1)

 

[XXD]

Thanks alot!!! Thank you



XXD