Combo Box Dropdown

L

Lamar

I created a combo box to "Find a record on my form based on the value I
enter in combo box". From the dropdown menu the combo box displays the last
and first name of clients as the user enters the last name. For some reason
the dropdown menu will not go past the letter "M". So if I enter the name
"Watson" the dropdown menu does no go to the "Ws' but stay in the "Ms".

I can look up names great unless the last name begins with any letter past
"M". The record source for the form is a query that has over 100,000
records.

Thanks for any help - Lamar
 
K

KARL DEWEY

Is the Row Source of the combo the query name or a SQL statement? If so, are
there criteria in it?
Are there any mask or validation set for the combo?
 
L

Lamar

It is SQL and there is criteria (see below). There is no mask or validation
for the combo box.

SELECT [Completed Requests Query].ID, [Completed Requests
Query].IndividualLast, [Completed Requests Query].IndividualFirst
FROM [Completed Requests Query]
WHERE ((([Completed Requests Query].IndividualLast) Is Not Null))
ORDER BY [Completed Requests Query].IndividualLast, [Completed Requests
Query].IndividualFirst;
 
J

John W. Vinson

I created a combo box to "Find a record on my form based on the value I
enter in combo box". From the dropdown menu the combo box displays the last
and first name of clients as the user enters the last name. For some reason
the dropdown menu will not go past the letter "M". So if I enter the name
"Watson" the dropdown menu does no go to the "Ws' but stay in the "Ms".

I can look up names great unless the last name begins with any letter past
"M". The record source for the form is a query that has over 100,000
records.

Thanks for any help - Lamar

That's too many for a combo: it's limited to (an absurdly large) 65536 rows.

Try setting the combo's row source to nothing, and actually assigning it in
the combo's Change event:

Private Sub cboMyCombo_Change()
Me!cboMyCombo.RowSource = "SELECT <some fields> FROM Clients WHERE LastName
LIKE Left(Me!cboMyCombo, 1) & ""*"""
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top