General information
Category:
Forms & Form designer
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only