Combo displaying data problem

  • Thread starter Thread starter Stanley Leeds
  • Start date Start date
S

Stanley Leeds

All,

I have a Combo Box that I populate with a query as such
Field1 Field2 field3 filed4 sorted field1 and then 2
The box is bound to field3 and gets correctly updated to the combo which in
turns updates correctly into my table/field.

Teh problem is that when teh Form diplaying the box is opened or after
making an update, it show the info d stored in field1.

I've beat myself silly, so I could use some help. I want it to show the
info (field3) that is stored in table nto the query.

Stan
 
Stan,

A combobox displays the data from the first visible column of its
RowSource. In your example, this is Field1. If you want to see the
data in Field3, you will need to do one of 3 things...
- Shift Field3 to the left-most column in the query
- Set the ColumnWidths property of the combobox such that the first 2
columns are 0 wide
- Leave the combobox as it is, and add an unbound textbox to the form,
with its controlsource set to =[ComboboxName].[Column](2)

- Steve Schapel, Microsoft Access MVP
 
Back
Top