General information
Category:
Coding, syntax & commands
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.
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