subform requery

[Spyridon]

I have a form with a subform attached to it. After I login to the database, it automatically pops this form. Everything looks fine, except that there are no records. What is throwing me off is that when I hit the design view, and then the form view, even if I don't make any changes, the records are all there. Anyone have an idea why this is? I've tried putting "me.requery" in the subforms load,open, and activate events.. but no luck.

Help please


Michael

 

[Sorrells]

Spyridon,

A few questions for clarity.
- What version of Access
- design then open which - main form or subform
If it is the subform then I'd check the Link Child/Master Fields property for the subform from within the main form. If either your Main or subform form is unbound there should be no entries there, if they both are bound then you should show the related fields in these properties.

Hope this helps some........

Regards, Sorrells