- Joined
- Jan 22, 2014
- Messages
- 1
- Reaction score
- 0
I'm new to Ms Access 2010 and need some assistance.
I have a Main form with three "Tab Control" sheets. On one of the Tab control sheets there is Subform. The main form refers to orders and the subform refers to Order details. Relationship has been established between the two tables used and is working. When populating the forms the first time, the tables are saved with the correct information. When I try and add a new record, the table on the subform is displaying previous records. The first table will then save the new information but the record in the 2nd table is overwritten.If I take these same forms and try and update WITHOUT a tab control sheet, everything works correctly.
What am I missing?
I have a Main form with three "Tab Control" sheets. On one of the Tab control sheets there is Subform. The main form refers to orders and the subform refers to Order details. Relationship has been established between the two tables used and is working. When populating the forms the first time, the tables are saved with the correct information. When I try and add a new record, the table on the subform is displaying previous records. The first table will then save the new information but the record in the 2nd table is overwritten.If I take these same forms and try and update WITHOUT a tab control sheet, everything works correctly.
What am I missing?