>Hi
>
>I have a combobox of customer codes on my form,
>
>the source for the combobox is SQL into a cursor.
>
> the user wants a quick way of adding new customer codes on the fly, so I've added a Add command button that runs another modal form that adds a new customer code into the CUSTOMERS table, I then requiry the combobox, and want to set the value of the combobox to the new added code,
>
>But the value stays blank in the combobox?
>
>Any help extremley appreciated
Try navigating to the record in the cursor in addition to setting the value and displayvalue.
If it's not broken, fix it until it is.
My Blog