>Terry,
>
>I'd try and steer you away from code that is that order dependent. If you use the Send To Back and Bring To Front you can control the order of the records in the SCX, but again this isn't an optimal solution.
>
>The Refresh() event is designed to allow a control to reflect a change in it's underlying ControlSource, ie a record navigation. It sounds more like you need to be using the Valid(). But the order dependency can still be really bad. Users can use the mouse to sequence through controls in any order they feel like.
>
>If you've got several controls to validate as a group in a particular order I'd use one custom Form method that processed each control in order, if invalid data is there the method can SetFocus() to the appropriate control. Then all of the controls Valid() methods just look something like:
>
>DoDefault()
>return thisform.Validate()
>
Thanks David

My issues are fairly straight forward enough to be able to use the bring to front option. It usually just envolves one control ie Employee Classification.

I hadn't thought of bring to front.

Thanks
Terry