T
tuesamlarry
Main form: frmClientNew
Subform: sfrmClientIncomeNew
Control on Subform: incmNameOnIncome
Main form is opened hidden, in Add mode upon opening database. Because this
form is complex and takes a while to load, I just make it Visible when I want
to use this form to enter a new record, and then hide it when "closing" it,
thus making it instant on/off. The close routine performs an acNewRecord, so
that when I "open" frmClientNew again, it is at a blank form and I enter
another record. I want the subform control to populate a combo box with the
names of the household individuals for the current record, (which I enter on
a second subform). I have placed a Requery in 2 places;
1)Form_Current event of the sfrmClientIncomeNew....
Me.incmNameOnIncome.Requery
2)incmClientID_AfterUpdate (foreign key linking subform with main
form)....Me.incmNameOnIncome.Requery
This works for the first time I "open" frmClientNew. The names which I have
entered (through a second subform; sfrmFamilyMembers) populate my combo box
on sfrmClientIncomeNew perfectly. However, the second time I "open"
frmClientNew, no names appear in the combo box list. I have tried putting the
requery in various other places, but again either get zero names or the
names from the previous record. I assume my problem stems from
hiding/unhiding the form versus opening/closing. How can I get my combo to
populate itself correctly under this scenario? Appreciate any help.
Subform: sfrmClientIncomeNew
Control on Subform: incmNameOnIncome
Main form is opened hidden, in Add mode upon opening database. Because this
form is complex and takes a while to load, I just make it Visible when I want
to use this form to enter a new record, and then hide it when "closing" it,
thus making it instant on/off. The close routine performs an acNewRecord, so
that when I "open" frmClientNew again, it is at a blank form and I enter
another record. I want the subform control to populate a combo box with the
names of the household individuals for the current record, (which I enter on
a second subform). I have placed a Requery in 2 places;
1)Form_Current event of the sfrmClientIncomeNew....
Me.incmNameOnIncome.Requery
2)incmClientID_AfterUpdate (foreign key linking subform with main
form)....Me.incmNameOnIncome.Requery
This works for the first time I "open" frmClientNew. The names which I have
entered (through a second subform; sfrmFamilyMembers) populate my combo box
on sfrmClientIncomeNew perfectly. However, the second time I "open"
frmClientNew, no names appear in the combo box list. I have tried putting the
requery in various other places, but again either get zero names or the
names from the previous record. I assume my problem stems from
hiding/unhiding the form versus opening/closing. How can I get my combo to
populate itself correctly under this scenario? Appreciate any help.