J
Jack
I am using Access2003.
I have a MainForm that has two subforms.
The first Subform is dependent on a selection
from a ComboBox on the Main form
The Second SubForm is dependent on the first Subform.
Everything works fine under normal cercumstances.
But when I try to use code to add a record to the
Combo Box selections, the subforms don't get
updated for the new selection in the ComboBox until
I close & reopen the form.
To add the NEW record to the combo box, I open a
small form that alows me to add a record and then
when I close that form i requery the combobox.
I've even tried requerying the subforms but that
doesn't work either.
Any ideas?
Thank you
I have a MainForm that has two subforms.
The first Subform is dependent on a selection
from a ComboBox on the Main form
The Second SubForm is dependent on the first Subform.
Everything works fine under normal cercumstances.
But when I try to use code to add a record to the
Combo Box selections, the subforms don't get
updated for the new selection in the ComboBox until
I close & reopen the form.
To add the NEW record to the combo box, I open a
small form that alows me to add a record and then
when I close that form i requery the combobox.
I've even tried requerying the subforms but that
doesn't work either.
Any ideas?
Thank you