Hi John --

Once again, it is late at night and I got a lot accomplised tonight on my views for my office search form. I definitely had some problems there to take care of, which I believe I did.

My question revolves aroud something I forgot to implement that you wrote, which were the two methods, CurrentState_Assign and CurrentCounty_Assign.

You said to create these at the form level and put code into two methods to REQUERY the county and city views and refresh the combos those views are attached to:

Would that code be the same code in my interactivechange event for my state and county combo boxes?

In those combos' interactivechange event, I have:

A. state combo:

THISFORM.CurrentState = THIS.Value
=REQUERY("county_search_pview")
=REQUERY("locality_search_pview")
THISFORM.cmbcounty_search.refresh()
THISFORM.cmblocality_search.refresh()

B. County combo:

THISFORM.CurrentCounty = THIS.Value
=REQUERY("locality_search_pview")
THISFORM.cmblocality_search.refresh()

C. I do not have code in my locality (city) combo box interactivechange event



Do I have to place this code back into the CurrentState_Assign & CurrentCounty_Assign methods to make my form/combos/pviews work? I'm just note sure how these methods fit into the picture.

One more note, when I created my CurrentState_Assign and CurrentCounty_Assign, it was placed into my properties form with code in it already.

It said>

lparameters vNewVal
This.CurrentState_Assign = m.vNewVal

I didn't put that code there.... That just showed up as soon as i created the new method. Should I delete that and enter my code? If I enter code in the Assign, do I take it out of the interactivechange event, or should I just leave it alone?

Thanks for any additional guidance

Jason