>>>Ok, so the properties of my combobox are as follows:
>>>
>>>Control Source: m.customer (I'm not buffering directly to a table, but APPENDING BLANK etc from the save button of my form)
>>>
>>>
Name: CmbCCustomer
>>>
>>>Row Source: select * from customers into cursor tmpcustomers order by customer readwrite
>>>
>>>Row Source Type: 3 SQL Statement
>>>
>>>Style: 2 Dropdown List
>>>
>>>
>>>
>>>in my CUSTOMERADD form I'm doing the following: (some of which is probably not needed):
>>>
>>>
>>>IF !SEEK(ALLTRIM(thisform.txtCCode.Value),"customers","customer")
>>> INSERT INTO customers (customer,companyname) VALUES (thisform.txtCCode.Value,thisform.txtCCompanyName.Value)
>>> INSERT INTO tmpcustomers (customer,companyname) VALUES (thisform.txtCCode.Value,thisform.txtCCompanyName.Value)
>>>ENDIF
>>>thisform.Release
>>>
>>>
>>>Maybe just adding into the CUSTOMERS file & then requerying the combo would be better than adding into my cursor for the combo ?
>>>
>>>Rob
>>>
>>>
>>Yes, you don't need to add it in the tmpCustomers. I always just use RowSourceType - alias, not the SQL.
>
>Ok. I'm now setting m.customer, and setting the display value, and its now working most of the time, not sure why it doesn't work 100% of the time, but I'm obviously nearly there!
>
Have you called the combo's Requery after adding the new value to the RowSource?
Tamar