Re: Problem Between Access 2003 & Access 2007 Displaying Forms Correctly, Office 2007
I saw a post by Allen Browne the other day about a similar problem. I don't run Access 2007/2010, and so can't check this, but apparently there is a new Property for Forms named Filter On Load. Check it for the errant Subform and if set to Yes change it to No.
If set to Yes it automatically applies a previously saved filter the next time the Form opens, giving unexpected results at times.
The Devil's in the Details!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
(All code solutions tested in Access 2003/2007, before posting, unless otherwise noted.)