Daft combo box problem: whats going on?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scubadiver - 15 Mar 2007 12:04 GMT

I am having a lot of trouble binding the second column of a combo to the
record source.

If the "boundcolumn" property is set to 2 and I choose from the list, it
doesn't show what I want BUT if I then change the property to 1 and go back
into the form it then shows the field correctly BUT if I then choose another
from the list it reverts back to showing the wrong column.

Is there something I'm missing (tho I can't think what!)

thanks

Reply to this Message

BruceM - 15 Mar 2007 12:14 GMT

Make sure the column count is 2. If you want to see the second column, set
the column widths to something like 0";1.5". Also, if Limit to List is set
to No, the bound column needs to be the first visible column. Is the row
source fixed, or is it being set on the fly?

> I am having a lot of trouble binding the second column of a combo to the
> record source.
[quoted text clipped - 9 lines]
>
> thanks

Reply to this Message

scubadiver - 15 Mar 2007 12:27 GMT

At the moment

Column count: 2
Column width: 1.5cm;10cm
Row source: fixed
Bound column: 2
Limit to List: Yes

thanks

> Make sure the column count is 2. If you want to see the second column, set
> the column widths to something like 0";1.5". Also, if Limit to List is set
[quoted text clipped - 14 lines]
> >
> > thanks

Reply to this Message

BruceM - 15 Mar 2007 15:31 GMT

This statement is unclear:
"If the "boundcolumn" property is set to 2 and I choose from the list, it
doesn't show what I want BUT if I then change the property to 1 and go back
into the form it then shows the field correctly BUT if I then choose another
from the list it reverts back to showing the wrong column."

Does your Row Source have 2 columns? If so, your combo box will show both
columns. When you say "it doesn't show what I want", do you mean the
drop-down list is other than what you expect? If so, what do you expect?

> At the moment
>
[quoted text clipped - 28 lines]
>> >
>> > thanks

Reply to this Message

scubadiver - 15 Mar 2007 15:48 GMT

The row source does have two columns, it is the source I want. I want to
show both but I want the bound column to be column 2.

If the "boundcolumn" property is set to 2 and I choose from the list, it
shows column 1. If I then go into the design and change the property to 1 and
go back into the same record the field shows column 2 (automatically) BUT
when I choose another from the source list it then reverts back to choosing
column 1.

I can't be much clearer than this.

> This statement is unclear:
> "If the "boundcolumn" property is set to 2 and I choose from the list, it
[quoted text clipped - 38 lines]
> >> >
> >> > thanks

Reply to this Message

BruceM - 15 Mar 2007 16:28 GMT

I asked several questions, and received an answer to only one. The other
questions were relevant.
I take it that the combo box is bound to a field (an unbound combo box has a
bound column, so the fact that there is a bound column says nothing about
the Control Source).
According to the properties you provided, when you click the down arrow on
the combo box you see both columns. Is that correct?
When you say "it shows column 1", do you mean the list displays column 1, or
do you mean that after making the selection the column 1 value is displayed?
In other words, what is "it"?
If you change the bound column to 1 and the underlying field will not accept
that data type, the field may revert to the previous value, but I'm not
completely sure about that.

> The row source does have two columns, it is the source I want. I want to
> show both but I want the bound column to be column 2.
[quoted text clipped - 59 lines]
>> >> >
>> >> > thanks

Reply to this Message