If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tabbed Pages Not Refreshing
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 |
#2
|
|||
|
|||
Tabbed Pages Not Refreshing
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 "PA" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|