Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Interactive change event
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00059786
Message ID:
00060334
Views:
27
>>I appreciate you doing this. Okay here is the situation.
>>
>>I have a grid than can be edited. The first value in the grid can have 3 values, so I have used a combo box. The grid is also sorted on this column, so naturally the grid has to be reordered when the values changes.
>>
>>In the combobox in column one I put this code in the InteractiveChange event
>>
>>=requery("schedname")
>>thisform.refresh
>>
>>It doesn't fire after a new combobox value has been selected. If I put the code in the Valid event, it fires correctly.
>>
>>What have I done wrong? Hopefully I am not trying to pound a nail with a screwdriver :-).
>Evan,
>
>The problem that you are having is that the controlsource of the combo has not hcanged when teh interactivechange event fire because controls update thier controlsources just before the Vlaid fires. So when you requery in the interactivechange, it works, but nothing changes becuase the combo's value has changed but it has not yet updated the underlying field in the view. If you do the same thing in the valid it also wokrs, but in this case the controlsource for the combo has been updated and so you see a different result. Fior the behavior that you want you will need ot use the valid event to do the requery.

Ahh... thank you!

I thought the answer would be something like this. I am printing this one for the "foxpro" file.

Perhaps this was a case of using a roberson instead of a phillips? :-)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform