Continuous form – bound combo box utilizing on change code to narrow a user search as values are entered. When the first character is entered Access seems to fire a query and the on change code references a single user. I have to backspace to clear this value and then the search code works correctly. Making it unbound works great but I do not know how to set the initial value as stored in the database.
-
-
I could go into detail about this but it is best if you check out the article written by Allen Browne. This should help you accomplish the task.
P.S.- He's a member here!:)
Comment