K
KC Classic
I have a form that changes with a parameter that is entered through a combo
box. The syntax of the parameter follows:
Forms!frmWhatState![cboStateCode]
This parameter is entered in underlying crosstab queries that supply my main
form named frmStateCriteria. In an effort to try to broaden the amount of
information supplied by this form, I have added tab controls and subforms to
the main form and the form now displays monthly/quarterly totals filtered by
the State Code. My form displays the correct result set and totals by state
as requested. The problem occurs when I change the State Code parameter in
my combo box. I change from say CA (California) to GA (Georgia) and main form
does not change as requested. The additional tabs that display the
monthly/quarterly information are not updated based upon the new State Code
criteria. I believe the problem has to do with the linking of my
forms/subforms but the reading I have done to date has further confused the
issue in my brain. I have tried to Requery using a macro but am not sure
where to run the macro - on the main form or my subform(s).
My goal is to have the monthly/quarterly totals update as the State Code
parameter is changed. Currently, the change will occur but only when the
main form is closed and reopened. I would like to be able to change the
parameter on frmWhatState and have the information follow suit on my main
form.
Anyone have any suggestions?
KC Classic
box. The syntax of the parameter follows:
Forms!frmWhatState![cboStateCode]
This parameter is entered in underlying crosstab queries that supply my main
form named frmStateCriteria. In an effort to try to broaden the amount of
information supplied by this form, I have added tab controls and subforms to
the main form and the form now displays monthly/quarterly totals filtered by
the State Code. My form displays the correct result set and totals by state
as requested. The problem occurs when I change the State Code parameter in
my combo box. I change from say CA (California) to GA (Georgia) and main form
does not change as requested. The additional tabs that display the
monthly/quarterly information are not updated based upon the new State Code
criteria. I believe the problem has to do with the linking of my
forms/subforms but the reading I have done to date has further confused the
issue in my brain. I have tried to Requery using a macro but am not sure
where to run the macro - on the main form or my subform(s).
My goal is to have the monthly/quarterly totals update as the State Code
parameter is changed. Currently, the change will occur but only when the
main form is closed and reopened. I would like to be able to change the
parameter on frmWhatState and have the information follow suit on my main
form.
Anyone have any suggestions?
KC Classic