Probably you are talking about combobox having style 0 Drop-down Combo, with controlsource as "a field in a table", and with initial rowsource as field values in the controlsource field, and with validation routine that recreates the rowsource when user enters values not in the initial rowsource.

Looks like you need to add the form property as an indicator of whether the rowsource has been already updated to avoid subsequent rowsource recreation.
Or/and you may try to change the STYLE to 2 after rowsource is recreated, or just switch to another combobox in the code.


>I need a combobox to be bound to a field in a table. The field on any given record will contain one of three values: blank, a value which is in the combobox's rowsource, or a value which is not in the combobox's rowsource.
>
>I want the combobox to display the field value to the user in all cases.
>
>I also want the combobox to accept the same three different values from the user and save them in the field (ie. blank, non-rowsource value, rowsource value)
>
>The rowsource may contain a large number of values which have to be retrieved from a database situated across the network,and I don't want to load the rowsource unless the user actually decides to change a value (or clicks on the dropdown).
>
>Can someone tell me the best way to achieve this?