records within nested subform

[rob mccoy via AccessMonster.com]

Steve,
I've got the [payroll] subform within the [main] form and [pay period details] within [payroll]. Each record in the [main] form represents one employee. Each record in [payroll] represents on pay period (week) . Each record in [pay period details] represents on day... so - for each employee there will be multiple records for [payroll] (a new one each week), and likewise - for each [payroll] record there will be 7 [pay period detail] records. so - the problem is - how to keep all of these record and sub record sets attached, and specific, to each individual employee. Everything seems to work except the [pay period details] nested subform. If I scroll through the employee records on the main form - all of the subfom record sets will change accordingly, but the [pay period details] that is nested in [payroll] - you can scroll through all of it's records just like it was unbound, but it is bound to the table. I figure that I'm overlooking something goofy. Any ideas?

thanks...

....rob

 

[Brian]

Steve,
I've got the [payroll] subform within the [main] form and [pay period

details] within [payroll]. Each record in the [main] form represents one
employee. Each record in [payroll] represents on pay period (week) . Each
record in [pay period details] represents on day... so - for each employee
there will be multiple records for [payroll] (a new one each week), and
likewise - for each [payroll] record there will be 7 [pay period detail]
records. so - the problem is - how to keep all of these record and sub
record sets attached, and specific, to each individual employee. Everything
seems to work except the [pay period details] nested subform. If I scroll
through the employee records on the main form - all of the subfom record
sets will change accordingly, but the [pay period details] that is nested in
[payroll] - you can scroll through all of it's records just like it was
unbound, but it is bound to the table. I figure that I'm overlooking
something goofy. Any ideas?

thanks...

...rob

Sounds like the form is bound but not linked. For the subform control, make
sure that the appropriate linking fields are specified in the Link Child
Fields and Link Master Fields properties.