Calling form from combo box

[Guest]

I have a form “frmGrantsData†that has 2 subforms,
“frmSelectLocalContactDataEdit†and “frmSelectFundingProgramDataEditâ€, both
subforms are in a many to many relationship with the form. 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.

 

[Guest]

The Change event is probably not the correct place for what you are doing. I
suggest you move your code to the After Update event. The Change event fires
for every change, which means every keystroke. You really would rarely use
the Change event, especially for a combo box. Between the Autoexpand and the
Change event firing every keystroke, timing can become a problem.

 

[Guest]

Sorry that did not help. I would not be against sending a copy of the
database, I just do not know how to change the file type.
JimN (e-mail address removed)