Auto expand on combo doesnot work for double names

[Frank Situmorang]

Hello,

my combo box row source is from query of membertable order by member ID

If there is to names are the same, like Henry Johnson Manik member id 102
and the other is Henry Panjaitan member ID 110,

The autoexpand is onlsy showing Henry Johnson Manik. Even though we type
close to the 2nd one e.g: Henry P..auto expand does not show/complete to
Henry Panjaitan, even we type completely there will be a debug. The way we
enter is by scrolling down to Henry Panjaitan and then we enter.

Can anyone help me how can it auto expand to the 2nd one. Because scrolling
down will be a waste of time.

Thansk in advance

 

[John W. Vinson]

Hello,

my combo box row source is from query of membertable order by member ID

If there is to names are the same, like Henry Johnson Manik member id 102
and the other is Henry Panjaitan member ID 110,

The autoexpand is onlsy showing Henry Johnson Manik. Even though we type
close to the 2nd one e.g: Henry P..auto expand does not show/complete to
Henry Panjaitan, even we type completely there will be a debug. The way we
enter is by scrolling down to Henry Panjaitan and then we enter.

Can anyone help me how can it auto expand to the 2nd one. Because scrolling
down will be a waste of time.

Thansk in advance

Please open the combo's Row Source query in SQL view and post the SQL text
here; it would also help to post the combo's Column Count, Bound Column and
ColumnWidths properties.

 

[Frank Situmorang]

Thanks John for your willingness to help me. This is row source:
SELECT BukuAngKbyQuery.FullName, BukuAngKbyQuery.LNAME,
BukuAngKbyQuery.NO_URTANGT FROM BukuAngKbyQuery ORDER BY
BukuAngKbyQuery.LNAME;

And here is data property:
Column Count = 3 and Bound Column = 1 and
ColumnWidths = blank ( shows nothing)

Thansk in advance

 

[John W. Vinson]

Thanks John for your willingness to help me. This is row source:
SELECT BukuAngKbyQuery.FullName, BukuAngKbyQuery.LNAME,
BukuAngKbyQuery.NO_URTANGT FROM BukuAngKbyQuery ORDER BY
BukuAngKbyQuery.LNAME;

And here is data property:
Column Count = 3 and Bound Column = 1 and
ColumnWidths = blank ( shows nothing)

Thansk in advance

Shouldn't you be storing the MemberID rather than the last name??? Is
NO_URTANGT the ID field? if so what's its datatype?

And are you storing both the fullname and the LName? I would recommend instead
having separate fields for FirstName, MiddleName, LastName, and basing your
combo on a query like

SELECT NO_URTANGT, [FirstName] & (" " + [MiddleName]) & [LastName] FROM
BukuAngKbyQuery ORDER BY FirstName, MiddleName, LastName;

assuming you want to see "Henry Johnson Manik" followed by "Henry Panjaitan";
as it is, you'll see the records sorted *BY LAST NAME* and those two names
might be separated by many records.

 

[Frank Situmorang]

Thanks John for your willingness to help me. This is row source:
SELECT BukuAngKbyQuery.FullName, BukuAngKbyQuery.LNAME,
BukuAngKbyQuery.NO_URTANGT FROM BukuAngKbyQuery ORDER BY
BukuAngKbyQuery.LNAME;

And here is data property:
Column Count = 3 and Bound Column = 1 and
ColumnWidths = blank ( shows nothing)

Thansk in advance

Shouldn't you be storing the MemberID rather than the last name??? Is
NO_URTANGT the ID field? if so what's its datatype?

And are you storing both the fullname and the LName? I would recommend instead
having separate fields for FirstName, MiddleName, LastName, and basing your
combo on a query like

SELECT NO_URTANGT, [FirstName] & (" " + [MiddleName]) & [LastName] FROM
BukuAngKbyQuery ORDER BY FirstName, MiddleName, LastName;

assuming you want to see "Henry Johnson Manik" followed by "Henry Panjaitan";
as it is, you'll see the records sorted *BY LAST NAME* and those two names
might be separated by many records.

 

[Frank Situmorang]

Thanks John, Full name is a calculated field to combine all First , Middle
and last Name. What I just did is order by full name. Now it is OK

Thanks very much

Frank

Thanks John for your willingness to help me. This is row source:
SELECT BukuAngKbyQuery.FullName, BukuAngKbyQuery.LNAME,
BukuAngKbyQuery.NO_URTANGT FROM BukuAngKbyQuery ORDER BY
BukuAngKbyQuery.LNAME;

And here is data property:
Column Count = 3 and Bound Column = 1 and
ColumnWidths = blank ( shows nothing)

Thansk in advance

Shouldn't you be storing the MemberID rather than the last name??? Is
NO_URTANGT the ID field? if so what's its datatype?

And are you storing both the fullname and the LName? I would recommend instead
having separate fields for FirstName, MiddleName, LastName, and basing your
combo on a query like

SELECT NO_URTANGT, [FirstName] & (" " + [MiddleName]) & [LastName] FROM
BukuAngKbyQuery ORDER BY FirstName, MiddleName, LastName;

assuming you want to see "Henry Johnson Manik" followed by "Henry Panjaitan";
as it is, you'll see the records sorted *BY LAST NAME* and those two names
might be separated by many records.