>Yes, subclass it if there is any chance you will be using it again somewhere else. In general, you can use an SQL statement to load the combobox. If you want the box to display certain data, build a select statement to retrieve certain records and populate the combo with that list.
-1 I've got the combobox working with an sql statement doing a select in the rowsource. But how do I get the combobox to display all the first item that begins with a '9' if the user types in a 9?
-2 why subclass this if it needs to be tailor made for this specific app?
Thanks for your help.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."