Good Morning all.....I have had an ongoing dilema which i have been ignoring thus far. In a como box with say 3 columns. After you pick from the list how do i get all 3 to remain in the box as opposed to just the bound column????
The above quote is referring to the “Column Widths” property on the property sheet for the combo box. The first column with a positive, non-zero value is the one displayed after the selection from the drop down list has been made.
So what I typically do to get “multiple columns” to display after the selection has been made is to edit the row source property of the cmbbx by clicking on the ellipsis (…). Then I create a calculated field in the row field of the SQL Statement: Query Builder that concatenates the data from the table fields I want to see after the selection is made. Like so: