Combo Box Assistance Needed

[DaKetch]

I have an input form that has a combo box that looks up an Employer. The box has the following SQL attached:



SELECT [tbl_AgencyInfo].[ID], [tbl_AgencyInfo].[Agency_Name], [tbl_AgencyInfo].[Agency_Address], [tbl_AgencyInfo].[Agency_City], [tbl_AgencyInfo].[Agency_State], [tbl_AgencyInfo].[Agency_Zip], [tbl_AgencyInfo].[Agency_Phone_1] FROM tbl_AgencyInfo ORDER BY [Agency_Name];

I would like to then take the Address add a vbCRLF then place the City, state zip on the second line of the Address box.

I don't want to create a subform for a single field on the form. Does anyone know of a way to complete this?

Thank you!

[June7]

If you want to display the address info in a textbox:

=[comboboxname].Column(2) & Chr(13) & Chr(10) & [comboboxname].Column(3) & ", " [comboboxname].Column(4) & " " & [comboboxname].Column(5)

[DaKetch]

Thank you, June7!

That worked!