How to assign an initial value to an unbound combobox

[Scott Spaman]

Hello,

New to Access/VBA so I hope this question is fair. Continuous form displaying multiple records. I tried implementing a bound combo box utilizing on change code to narrow a user search as values are entered. Builds a wildcard based sql statement and applies it to rowsource. Works great except when the first character is entered Access seems to fire a query and a single user is loaded before entering the on change code. I have to backspace to clear this value and then only the characters entered are referenced in the on change code. Making it unbound works great but I do not know how to set the initial value as stored in the database. Any recommendations ?

thank you,

Scott

[Mr Key]

Wecome Scot!
It seems you are doin great with access, may you please attach the sample of your design so that we can understand much better of what you are trying to tell us!!