Name: CmbCCustomer Row Source: select * from customers into cursor tmpcustomers order by customer readwrite Row Source Type: 3 SQL Statement Style: 2 Dropdown Listin 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.ReleaseMaybe just adding into the CUSTOMERS file & then requerying the combo would be better than adding into my cursor for the combo ?