The problem stems from the data source not being written to until the control has lost focus. In the Grid refresh code, can you use the Combo value instead of the underlying data source.
I know this creates coupling but it sounds like you have that going on anyway.
HTH.
>I have two controls that work together
>
>1) A Combo Box which has a field in a table as a ControlSource
>2) A Grid which displays information based on a query of information using
>the same table.
>
>When I change the value in the Combo Box, I want the Grid to requery the table and show the results.
>
>The refresh method of my grid contains the code to:
>Set the recordsource to ''
>redo the query
>reset the recordsource to the result of the query
>
>I have tried to place code in both the VALID and the LOSTFOCUS of the combo box to either refresh the grid, or to refresh the form. The form will not refresh unless I select the same value in the Combo Box twice.
>
>I have added a refresh button to the screen, which will force it to refresh the form. This works, but it is not correct.
>
>My uneducated guess is that the Combo Box has not yet updated the database by the time I tell the Valid to refresh. I am probably way off base.
>
>Any ideas?
>
>Thanks for your help.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao