Requery subform control from Main form

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top