microsoft.public.access

Do you requery that main form after you change the value in that combo box?
Use AfterUpdate event of that combobox:

Private Sub cboStateCode_AfterUpdate()
Forms!frmStateCriteria.Requery
End Sub

--

Ken Snell




"KC Classic" wrote in message
news:AD3DEC1C-3BAE-4A3C-9C83-E6CD909279F0@microsoft.com...
>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
>