Combo Box - additional information

[murk]

I have a form that eventually turns into a report, where I would like to be able to enter an agency# and have the entire agency name show up along with it in the fields below. Where and how?

Please and thanks!

 

[Hmadyson]

This is how combo boxes on reports are meant to work. Make sure that you either have a query or SQL that selects both columns (the agency # and agency name). Make sure that name is before #. Then in the combobox ColumnCount=2, BoundColumn=2, ColumnWidths=1;0. This will show the name, but really be attached to the number. You can use the same field in the form and report, although the report one will not pop open like the form one.