G
Guest
I have a form “frmGrantsData†that has 2 subforms,
“frmSelectLocalContactDataEdit†and “frmSelectFundingProgramDataEditâ€. Each
subform has a combo box that selects a “contact name†or “program name†from
a table list of existing “contacts†or “programs†respectively. Also in the
combo box list is an item “ Not In Listâ€. When “ Not In List†is selected
another form is called from the combo box’s OnChange Event using If-Then
DoCmd. Openform “----“ . The form called is “frmLocalContactData†or
“frmFundingProgramData†respectively. The “frmSelectLocalContactDataEditâ€
combo box works. When “ Not In List†is selected the combo box,
“frmFundingProgramData†is called and when data is entered in that form and
the “Close Form†Button is clicked the associated code populates the
appropriate fields in the subform “frmSelectLocalContactDataEditâ€. But in the
“frmSelectFundingProgramDataEdit†subform’s combobox, when “ Not In List†is
selected the form does not appear and the text “ Not In List†appears in the
subform’s “contact name†field. I have copied the
“frmSelectLocalContactDataEditâ€.combo box’s OnChange Event code format and
recopied and pasted all the appropriate object names in the OnChange Event
code, and replaced the combo box and replaced the code again and still the
form is not called. Can you give me a clue as to what can cause this? Again I
have recopied and pasted all object names in the code.
“frmSelectLocalContactDataEdit†and “frmSelectFundingProgramDataEditâ€. Each
subform has a combo box that selects a “contact name†or “program name†from
a table list of existing “contacts†or “programs†respectively. Also in the
combo box list is an item “ Not In Listâ€. When “ Not In List†is selected
another form is called from the combo box’s OnChange Event using If-Then
DoCmd. Openform “----“ . The form called is “frmLocalContactData†or
“frmFundingProgramData†respectively. The “frmSelectLocalContactDataEditâ€
combo box works. When “ Not In List†is selected the combo box,
“frmFundingProgramData†is called and when data is entered in that form and
the “Close Form†Button is clicked the associated code populates the
appropriate fields in the subform “frmSelectLocalContactDataEditâ€. But in the
“frmSelectFundingProgramDataEdit†subform’s combobox, when “ Not In List†is
selected the form does not appear and the text “ Not In List†appears in the
subform’s “contact name†field. I have copied the
“frmSelectLocalContactDataEditâ€.combo box’s OnChange Event code format and
recopied and pasted all the appropriate object names in the OnChange Event
code, and replaced the combo box and replaced the code again and still the
form is not called. Can you give me a clue as to what can cause this? Again I
have recopied and pasted all object names in the code.