General information
Category:
Forms & Form designer
Hello Tom.
i figure out if I put a check with the got focus it runs the customized event in the form at which it will refresh the combo and stuff... kinda works.
All you need in the GotFocus() of the dependent combo is this line:
This.Requery()
My point is that you do not need to keep re-setting the RowSource, RowSourceType, etc. This only needs to be done once, when the form is instantiated. The Requery() re-runs the SQL statement specified by the RowSource and refreshes the combo's internal list.
Now, why the ControlSource is not being updated is a separate issue and is not typical behavior.
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