Multi page Grid

[Mrall]

I have a form with a Pageframe that has 2 pages(tabs). The pageframe is located on half of the form. On the other half, is a picture along with the fields for the current record.

On each of the Pages(tabs) is a grid with only the "Select" field being an editable (logical)checkbox.

For the active page and record in the grid, I want the picture and fields to be displayed in the fields on the the other half of the form for that current record. I should be able to scroll up or down the grid and have the info change on the form.

Here's the twist.

When you click on the tab to change the page, a simular grid using a different database is displayed it should now update the the fields with the current record on the other half of the form from this new grid.

The fields are all the sames in both databases. The info is different.

I'm not sure how to do this. I can't set the control source for the fields to one of the grids because the grid changes when a new page is selected. I know I could make the two pages take up the whole form and place the picture and fields on both pages. I just think it looks really nice doing it my way.

Any Ideas? (I have a picture of the form if that would be helpful.)

 

[Mrall]

Sorry! That link may not be any good. Here is one that works.

 

[Mrall]

I haven't got the hang of this yet! This worked for me.

 

[TamarGranor]

Off the top of my head, what if you set the ControlSource for those controls to be a field name without an alias. Then when you change work areas, they should switch to the fields in the current work area. You'll have to do a refresh to have the change show, I'm sure.

Tamar