I'm a little fuzzy about what error you are getting, if any. So I'm guessing the DropDownList for the ComboBox is not displaying for you.
There are two things that I noticed that you might want to check.
The first is to include these two lines at the top of your Form:
- Option Explicit
-
Private bLookupKeyPress As Boolean
I'm pretty sure these are missing as you should be getting an error in
Combo83_Change()
since it is missing the following:
The other thing is that you mentioned you have two columns in your ComboBox but the example has only one. You may need to add the additional column into the Select String:
- sSQL = "SELECT Product from dbo.Customer_Item"
and/or make sure the ComboBox Properties ColumnCount and BoundColumn line up with the RowSource that is being created.