I have a combo box on a form that allowes the user to select a record to be displayed in the form. The problem is i have about 3000 records in the table. Is there any way you can create a drop down menu with all the letters of the alphabet, and then use that to filter the records available in the drop down menu?
I have a combo box on a form that allowes the user to select a record to be displayed in the form. The problem is i have about 3000 records in the table. Is there any way you can create a drop down menu with all the letters of the alphabet, and then use that to filter the records available in the drop down menu?
I have a combo box on a form that allowes the user to select a record to be displayed in the form. The problem is i have about 3000 records in the table. Is there any way you can create a drop down menu with all the letters of the alphabet, and then use that to filter the records available in the drop down menu?
You may be able to do this with what's referred to as cascading combo boxes. Do a search on the forum and you should should find plenty of posts on the topic...
There are many ways to improve this situation.
One thing I have done is NOT populate the combo box until the third letter is typed by the user.
Do this by making a 'Change' event behind your combo box. In the event, do something like:
If Len(Me.MyComboBox.Text) > 2 Then
Me.MyComboBox.RowSource = "SELECT........WHERE MyText Like '" & Me.MyComboBox.Text & "*'"
Me.MyComboBox.DropDown
End If