Hi,
I am creating an Access database form to store invoice information in the same file. This is a single user file, but tested on a few workstations..
I am using a combo box (CboSupplier_List) to display supplier names in the database. I have set the following as its properties:
Limit to list=Yes
Auto Expand = Yes
In the form load event I have the following statement
StrSQL = "Select Supplier_Name from tbl_Suppliers"
cboSupplier_List.RowSource = SQrSQL
In the NotInList Event of the Combo I am using the following code:
Msgbox "Please select a supplier from the list"
The problem I am facing is that, due to the Auto Expand Property of the Combo being Yes, when the users are typing progressively, a correct spelling, then the combo is performing well. But when they type in a spelling not in the list, then the combo takes about 10-15 seconds to process (apparently code), and then throws out the msg. This problem is again not occuring on all the machines I have tested on; It happening only on two machines, and they have the exact same OS and service Packs, as other machines I have tested this with.
I appreciate any help that can be given. Thanks in Advance!
Gautam