>So you are okay with the look and layout of the controls? You just want to make the data refresh?
>
>Putting This.Refresh in the Activate of each page frame may help, but it might cause a problem if you have a modeless form and switch to other forms and back, depending what else is on the page. For instance, I have a search button which brings up a separate (modal) form, and I go so far as to have a form property lNoRefresh, which I set to true before I call the search form, then in the Activate IF NOT ThisForm.lNoRefresh, This.Refresh.
>
>Similarly, if you have RELATIONs among the tables, the Activate can contain GO RECNO('Parent_Table') IN Parent_Table before the This.Refresh, which will position the pointers of the children (and grandchildren) tables at the first matching record. This may not be necessary if users are navigating to the Parent record on the form itself.


Hi Terry

I was wondering the best way to keep the relation between records.

Set Filter?
Set Relation?
Use the relation properties in the grid control?

Thanks

John