R
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
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