Bound a column but display another in a combo box 1

[thirty4d]

Hello,

I have a combo box that has 3 fields:


Ex:

ID:1 (column 0)
Station:8Upper (column 1)
Display:8 (column 2)

Although I still want to show all the 3 fields to the user,

but I want the Display field as a result.

How do I do that?

 

[braindead2]

I think I missunderstand you but it seems to get it to save
display then all you need to do is set bound column to 3. However you generally want to save the ID rather then the value.

Good Luck

 

[thirty4d]

braindead2,

I tested to bound all 3 different columns 3 different ways but each time but I keep getting either the ID or the Station but I couldn't get the Display field.

Thanks for the feedback

 

[braindead2]

Did you say column 3 or column 2

2 is the index 3 is the column

 

[SteveR77]

Try this.

If the combo box is based on a query change the field that you want to be bound (written to the table to be the first column that is displayed)

Normally it's not an issue but every now and then I have a problem with binding anything other than the first column.

HTH

Steve B-)

 

[thirty4d]

SteveR77,

I'm trying to limit my queries in my database, otherwise I'll have ten million queries. The combo box is based on a table with only 3 fields.

When you said first column, are you referring to the ID field?

The reason why it's necessary for me to get the Display field is because I will be merging these records into a Word Mail Merge where each record has specific location in the Word document.

Thanks for feedback