I have a form for entering data. I use a combo box linked to a table to select a record that has a person's SSN, Name and city. Once the proper record is highligted and selected only the first column is visible in the combobox. Is there any way to keep all 3 columns visible once a record is selected in the combobox?
Combobox
- Thread starter MDDDS
- Start date
- Local time
- Today, 10:29
- Joined
- Jul 9, 2003
- Messages
- 17,503
Not that I am aware of, however you can add text boxes to display the information contained within the combo box.
From memory, you add the following the to the Control source of the text box.
=[cboMyCombo].[Column](2)
The 2 indicates the third column in the combo box, as the columns in a combo box are numbered zero on up.....
From memory, you add the following the to the Control source of the text box.
=[cboMyCombo].[Column](2)
The 2 indicates the third column in the combo box, as the columns in a combo box are numbered zero on up.....
