Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing data from another sytem
Message
 
To
21/05/2004 10:45:01
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00905931
Message ID:
00906205
Views:
18
>Jojo,

>Thanks for the earlier code. I am still struggling.
>1)When I open up the free table then I need to set the rowsource for the >combo to the free tables uniqiue reference and narrative.(This is choice I >need to give to the user.
>This is data from the other systems free table.

You can put some code in the INIT Event of your Forms with the Combo Box
table should be opened before calling this code..
With thisform
    .combo1.rowsource = "Your_table_name.unique_field,narrative"
    .combo1.rowsourcetype = 6
Endwith
Hope this one can help...

If you want to put your selected records from the form with the grid into your first form and make that record as the record that appear to your combo box, you need to put some code in the control that get the focus when returns back to your first form..
With thisform
   .combo1.rowsource = "" && you need to clear out rowsource first
   .combo1.rowsourcetype = 0 && none
   .combo1.additem(cVar1)
   .combo1.additem(cvar2)
ENDWITH
After you finish selecting the record from additem, you must put back the rowsource of your combo box bound to a table somewhere else in your first form.

Note: Put some validation so that it will not additem to your combo box the next time that control got the focus...
Jojo R. dela Cuesta, B.Sc.
eConsultant, Programmer
Dalplus Technologies
http://www.dalplus.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform