Only getting id from combo boxes (1 Viewer)

[wgma]

I have a form that has a combo box called Shipper. There are 3 columns in the combo box, ShipperID, ShipperName, ShipperAddress. When a user selects an item in the dropdown then there is a textbox below that gets the address filled in from on the combo box.

I have created a report based on the same table that the form is based on. When the report is displayed all I get in the section for the shipper is the ShipperID. How can I get the ShipperName and ShipperAddress to populate that area instead?

Thanks.

 

[khawar]

Base your report on a query and incude shipper from shippers table using inner join

 

[wgma]

That works great. I need to combine 2 fields, shippers name and shippers address, but when I do I need to have a line feed after the shippers name so that the address starts below the name.

How so I do that?

Thanks for your help.

 

[khawar]

you can use [shippername] & "-" & [shipperaddress] in the query column

 

[boblarson]

That works great. I need to combine 2 fields, shippers name and shippers address, but when I do I need to have a line feed after the shippers name so that the address starts below the name.

How so I do that?

Thanks for your help.

Actually, you would do
[ShipperName] & Chr(13) & Chr(10) & [ShipperAddress]

 

[khawar]

Boblarson's solution is exactly according to your requirement

 

[wgma]

That works. Thanks!