Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filling in Combobox Value
Message
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01509298
Message ID:
01509371
Views:
118
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







>>It's still blank but when I click the dropdown its positioned not on the one I've justr added, but the one I've added the time before that?
>>
>>It's not absolutely consistent though, I'm going to have to come with a solution, off to bed now to sleep on it, it's midnight hear in the UK
>>
>>Best
>>
>>Rob
>>
>Ok, post tomorrow all properties of this combobox, it should not be that hard.
Rob
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform