M
Mishanya
I have ParentForm with a few sub- and subsubforms. Most of subs are based on
queries and are read-only, while a couple of them are search/enter ones
(single-forms).
When I select cboClientID in the ParentForm, all the subs are loaded (or
reloaded, since I only change the recordset in the cboClientID selection)
anew.The two search-enter -data subs are reloaded with the first relevant
records, while their record-selector Combos are also filtered by the
ParentForm' cboClientID' AfterUpdate event
(Me!SubForm.Form!cboSelector.Requery).
However, I want those enter-data subs to always load to a new entry. I don't
want, though, to set focus to its controls, since the user does not need to
enter new records that frequently, nor does it first thing while
opening/reloading the ParentForm.
Anything can be done?
queries and are read-only, while a couple of them are search/enter ones
(single-forms).
When I select cboClientID in the ParentForm, all the subs are loaded (or
reloaded, since I only change the recordset in the cboClientID selection)
anew.The two search-enter -data subs are reloaded with the first relevant
records, while their record-selector Combos are also filtered by the
ParentForm' cboClientID' AfterUpdate event
(Me!SubForm.Form!cboSelector.Requery).
However, I want those enter-data subs to always load to a new entry. I don't
want, though, to set focus to its controls, since the user does not need to
enter new records that frequently, nor does it first thing while
opening/reloading the ParentForm.
Anything can be done?