Displaying more than 1 Coloumn in Combo Box

[yepwingtim]

is this possible?
I need First Name, Last Name, and Address displayed (they are three columns) but it only displays the First Name in the Combo Box when I select.

I'm also wondering if I can Manually enter new values from the Combo box using the 3 columns.

Thanks~
________
Medical Marijuana Patients

 

[maxmangion]

if the fields are already in the combo box then you should set the column count property to 3 and set the width property as well.

 

[yepwingtim]

Um i think im confusing you a bit
When i hit the drop down box it displays all 3 columns
When i select one of the values it only displays 1 column which is the Last Name
________
Xxx tube

 

[maxmangion]

that happens because probably your combo is "bounded" to just 1 column. If you would like to display the other fields why don't you do that at query level by joining the lookup table in your query.

Also you can populate them via a dlookup, however, it is less efficient than the query method.

 

[yepwingtim]

if i append the fields together
how can i add new names & addresses in the combo box?

Thanks~
________
MONTANA MEDICAL MARIJUANA DISPENSARY