so I have two combo boxes that I am using to make selections from a table containing 76,000 + records
I have created and on change event to update the rowsource after the user types a few letters to reduce the selection down to a managable number and keep system speed up.
However if I type in Aceta into the combo box I expect it to show everything that starts Aceta in that field however it only shows a single return AcetagesicPrivate Sub FilterText_Change() If Len(Me.FilterText.text) >= 3 Then Me.FilterText.RowSource = "SELECT DISTINCT NONPROPRIETARYNAME FROM tblNDCList WHERE NONPROPRIETARYNAME like '" & Me.FilterText.text & "%' ORDER BY NONPROPRIETARYNAME" End If End Sub
however if I add one more letter and make it Acetam it correctly brings up a list of 40 or so items that match that as a start of Acetaminophen
but why does it not show correctly the first time.... ?
(for those wondering yes this is a list of medications).
If I try and set the field to re query after I change the rowsource it gives me an error about saving (even though the field is unbound) and the fact that it DOES update the list shows that it shouldn't be necessary