Combo Box w/ 2 columns (1 Viewer)

T

triscuit83

Registered User.

Local time

Yesterday, 23:20

Joined

Oct 25, 2006

Messages

24

• Jan 25, 2007

• #1

I Have a combo box i want to list a name in one column and a number in the other

I want the number to transfer from the combo box to another field that i figured out fine. but how do i get the first column with the name to save to a certain table?

thank you for the help

 

R

rborob

Registered User.

Local time

Yesterday, 20:20

Joined

Jun 6, 2006

Messages

116

• Jan 25, 2007

• #2

use

combo.column(0)

for the first column in a combo box to return its value

 

T

triscuit83

Registered User.

Local time

Yesterday, 23:20

Joined

Oct 25, 2006

Messages

24

• Jan 25, 2007

• #3

your going to have to dumb that down a bit. where exactly would i be putting that expression?

 

R

rborob

Registered User.

Local time

Yesterday, 20:20

Joined

Jun 6, 2006

Messages

116

• Jan 25, 2007

• #4

hmm..how do you intend to save it? inline SQL? a query? setting the name to a text box?
On the After_Update of the combo box put

Me.txtbox = Me.combobox.column(0)

that will assign the name of whatever it is to the text box. hopefully that will let you expand on your solution.

 

Mile-O

Back once again...

Local time

Today, 04:20

Joined

Dec 10, 2002

Messages

11,316

• Jan 25, 2007

• #5

triscuit83 said:

I want the number to transfer from the combo box to another field that i figured out fine. but how do i get the first column with the name to save to a certain table?

Click to expand...

Bind a query based on the table to the form. You should have no need to save more than one item from the combo to a table. If you do have such a need, then your table structure is likely to be at fault.