Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a way
Message
From
17/08/1999 08:55:40
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
13/08/1999 13:50:34
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00253465
Message ID:
00254475
Views:
21
Jim,
Most of the time ...combo.refresh in ARCC would cure it as already said. There is a special situation though. Your grid might be editable and buffered. In that case your combo's SQL wouldn't retrieve the newly entered but not tableupdated value. Thus combo would be blank. For those cases you could build a an SQL that would contain it too :)
select distinct .. from myTable ;
union ;
select thisform..mygrid...text1.value as fieldname ;
into cursor mycursor

* In lostfocus of combo
with this
.value = .displayvalue
.displayvalue = .value
endwith
Helps. Also you would need a ...combo.requery.
Cetin

>Mike,
>
> On my form that I am designing I have a grid with data that is from a view. On the same form I have a page frame with a combobox on it. What I want to do is when the user changes rows in the grid the combobox should change to the correct value. However, it doesn't. When I first go into the form and scroll through the grid nothing happens. If I click on the combo box the value gets updated. After the combobox starts working it sometimes loses it's value even though the column the controlsource is set to has data in it.
>
>Really wierd if you ask me. I had my Boss, who is an expert in VFP, and he is completely stumped. That is the reason for overlaying the combobox with a textbox.
>
>Any ideas????
>
>Jim
>
>
>>Hi Jim,
>>
>>>I have a textbox over laying a combobox. I want to be able to click the text box and have the list of items in the combobox appear/drop down. Is there a way to do this?
>>
>>You'll probably end up better (and happier) if you get your combo to work as expected instead of trying to jimirig a combo to it. So, whats your situation?
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform