Combo autocomplete stops completing

[John]

AC2007

I changed my combo's row source and then the autocomplete stopped
working. The combo is two columns, bound to the first.

First column is primary key (ID). Second column is a concatenation of
two fields (Descrip & UserID).

When I start typing letters of an existing description (Descrip), the
combo does not autocomplete. If I select a choice from the combo, it
does accept it. If I update the combo row source to just one column
(the primary key, ID), it will auto complete.

What am I missing? Does autocomplete only work when using the primary
key, single column view?

[GH]

On May 22, 4:11 pm, John <[e-mail]:

AC2007

I changed my combo's row source and then the autocomplete stopped
working. The combo is two columns, bound to the first.

First column is primary key (ID). Second column is a concatenation of
two fields (Descrip & UserID).

When I start typing letters of an existing description (Descrip), the
combo does not autocomplete. If I select a choice from the combo, it
does accept it. If I update the combo row source to just one column
(the primary key, ID), it will auto complete.

What am I missing? Does autocomplete only work when using the primary
key, single column view?

John,

When you try to type in that combo box, do you be get any error
message in the status bar indicating you cannot edit the field? Since
you have bound the combo box to your primary key field (assuming your
form is bound to the same table), the form considers your attempts to
type a value as an edit to the primary key. Is your intention for
this combo box to actually set the primary key of the underlying
record? If not and you just need to navigate to a record, unbinding
the control should fix your problem.

- GH

[CDMAPoster]

On May 22, 3:11 pm, John <[e-mail]:

AC2007

I changed my combo's row source and then the autocomplete stopped
working. The combo is two columns, bound to the first.

First column is primary key (ID). Second column is a concatenation of
two fields (Descrip & UserID).

When I start typing letters of an existing description (Descrip), the
combo does not autocomplete. If I select a choice from the combo, it
does accept it. If I update the combo row source to just one column
(the primary key, ID), it will auto complete.

What am I missing? Does autocomplete only work when using the primary
key, single column view?

You need to add 'WHERE Descrip IS NOT Null' to your row source. A
Null Descrip will cause (Descrip & UserID) to be Null even though
UserID may exist. The Null value will cause the autocomplete to cease
functioning.

James A. Fortune
CD********@FortuneJames.com

[John]

On May 23, 12:56 pm, [e-mail] wrote:

On May 22, 3:11 pm, John <[e-mail]:

AC2007

I changed my combo's row source and then the autocomplete stopped
working. The combo is two columns, bound to the first.

First column is primary key (ID). Second column is a concatenation of
two fields (Descrip & UserID).

When I start typing letters of an existing description (Descrip), the
combo does not autocomplete. If I select a choice from the combo, it
does accept it. If I update the combo row source to just one column
(the primary key, ID), it will auto complete.

What am I missing? Does autocomplete only work when using the primary
key, single column view?

You need to add 'WHERE Descrip IS NOT Null' to your row source. A
Null Descrip will cause (Descrip & UserID) to be Null even though
UserID may exist. The Null value will cause the autocomplete to cease
functioning.

James A. Fortune
[e-mail]

There are not any null values in the records. This is very odd
behavior. I create a form to test this and get the same result. The
combo auto expands, but as soon as I restart access and try again, the
auto expands stops working. The db is in a "trusted location" (access
2007).

An ideas what I'm doing wrong? This is driving me crazy!