Tabbed Pages Not Refreshing

[PA]

Access 2007, with two tables. Table A has field1 as the primary key field
Table B has field1(same as field1 in table A) and field2 as a dual primary
key. The two table are joined via an inner join using field1 (1 to many)
A form has been created, towards the top is field1 plus other fields from
table A
The form has 5 pages below, with field2 on each page.
If I create a new row on the first page of the paged portion of the form,
and enter a value into field 2, it will not show up on the other pages unless
I navigate to the next record on the main portion of the form and then go
back. The new value then propagates tothe contol for field2 on all the other
pages.
I can not determine what I did wrong here?
Thanks for any help.
Paul

 

[Jeanette Cunningham]

I suggest that you put the control for field2 on the suform, but not on the
tab control.
This would allow that control to show through the tab control on every page
of the tab control.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia