On one of my forms, I have an unbound combo box based on a query.
The query contains 6 columns. The 1st column is the "bound" column, but it is not seen by the user when the user clicks on the combo box. The user sees only the contents of Columns 2 through 6.
After making a selection and moving on to the next control on the form, the combo box shows only the contents of Column 2. What was previously visible in Columns 3 through 6 disappears.
I thought about putting an expression into the Query (instead of showing Columns 2 through 6 separately), but this option is NOT pleasing to the eye when you click on the dropdown arrow of the combo box.
QUESTION: Without resorting to an expression in the query, is there a way to "see" the contents of Columns 2 through 6 AFTER the user makes a selection?
The query contains 6 columns. The 1st column is the "bound" column, but it is not seen by the user when the user clicks on the combo box. The user sees only the contents of Columns 2 through 6.
After making a selection and moving on to the next control on the form, the combo box shows only the contents of Column 2. What was previously visible in Columns 3 through 6 disappears.
I thought about putting an expression into the Query (instead of showing Columns 2 through 6 separately), but this option is NOT pleasing to the eye when you click on the dropdown arrow of the combo box.
QUESTION: Without resorting to an expression in the query, is there a way to "see" the contents of Columns 2 through 6 AFTER the user makes a selection?