How to display certain listbox columns on form

[vector39]

Hi everyone



I have a query pulling info from 2 tables and a list box on a form with the record source set to that query. There's a total of 13 column fields but I just need 5 of them to display in the list box. In addition to this, I'm trying to set the remaining hidden columns to be bound to text boxes on the form. Essentially the user will see the info in the 5 listbox columns but additional information will can be seen in these textboxes. I changed the query to not show the other columns by unchecking "Show" and also I changed the column widths property from 1;1;1;1;1;1;...etc to 2;2;2;2;2;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0; etc. Five text boxes are set to the each column in the listbox (e.g. '=[Results].Column(n)') but I don't know how to set the other text boxes' control source to be set to the remaining hidden columns. If anyone can provide some feedback to this, that would be much appreciated. Thank you.

- Rookie Programmer

[June7]

Why set the query to not show fields? If fields are set to not show and there is no filter or sort criteria associated with them, the fields will not stay in the query and are therefore not in the listbox RowSource. Leave the Show box checked and manage display with listbox properties.

Set textboxes to display hidden columns the same way as visible columns.

[vector39]

Thank you