Hi John -- Thanks for the reply. I have a question, b/c sometimes (most of the time!), I am real thick!!!

I just want to make sure I understood your last message. Please let me know if I am wrong/right.

You basically said that having the _Assign (for both County and State) is a good practice, but in my case, since I put the same code into the interactivechange event, I do not need to repeat that process...correct?

I guess what I am getting at is, if I already have the code in the interactivechange event to requery the views and refresh the combos, I do not need the assign.

However, if I chose to do so, I could just keep one line of code in the interactivechange event:

THISFORM.CurrentState = THIS.Value

and

THISFORM.CurrentCounty = THIS.Value ( for my county combo)

and put the refresh code/requery code in the _Assign.

Am I correct in that assumption.



2. I mentioned to you that there was code that popped up autmatically when I created the _Asssign, and I am unclear on whether or not to leave that, and write code below it if I chose, or delete it and write code.

3. Last question for the day....

This is a syntax question. I need to requery the views in the INIT of my office_search form, and want to make sure I am typing in the write code.

REQUERY("county_search_pview")
REQUERY("locality_search_pview")


So much to learn, so little time!!!!!


Thanks for the help

Jason