I had a issue with linked master/child staying stable - found the work around that was working great until I attempted to use it in Access 2010 version - see my previous post.
this results conflict with 2010 and when i comment out the workaround then the old problem of only 1 record being displayed on the form rears its ugly head again.
'The forms within the AK3 version work perfectly, however not in Ak7. When I open the form with the multiple subforms in AK3 if functions correctly, but for some reason when the same form/subforms open in AK7 the subform (datasheet view) will only display 1 record when it should be multiple records. When I view this subform outside of the Main form/Subform it displays the data correctly. The Query returns the correct records etc.
Does anyone know why this is happening? "
any ideas on a better approach.