Subform data not showing in Access 2007

[JimmyN]

I have a database in Access 2000 format. It has a main form with two subforms. The data on the subforms comes from queries based on the values of two controls on the main form rather than by a Master/Child link. Everything works perfectly in Access up to version 2003. In Access 2007 one of the subform's data does not show. If I open the subform independently then the data shows fine but not when it is part of the main form. The other subform works as it should.

Can anyone help with this one?

 

[Remou]

I have found that in certain cases Access seems to add link child and master fields at runtime. I wonder if it could be the case here?

 

[JimmyN]

I have checked and both the Link Master Fields and Link Child Fields properties are null.

 

[Pampers]

Isn't it so that subforms open first?

Pampers
Keeping it simple can be complicated

 

[KenReay]

Hi have tried a requery of the subform? in the afterupdate event of the two criteria controls would seem to be the appropriate place, but not sure since you do not explain how they are populated or if they are bound/unbound.

does not explain difference in behaviour between 2003 vs 2007 of course

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Mr018]

Wouldn't the form's "Private Sub Form_Current() "
be a better fitting event for the requery since it is fired if the user chances records without modifing them.

Just my $.02