I am in the process of validating my Access 2003 database and the functionality working in the new Access 2007 environment w/o converting to 2007 - will have mixed environments for awhile.
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?
Thanks,
Karen