If typed value not in the list assigned to the row source, the value is not written to the controlsource. See mskb #Q140652 for workaround.

>I have a combo box which is tied to an sql-select, which gives account number selections.
>example list:
>
>103
>110
>230
>etc.
>
>However, sometimes the user wants to type in a value not within the account list (example: low range account = 100 when no account 100 exists). Is there a way to do this with the combo? Right now, values not matched up show blank and will not allow manual entry; only selections from the box.