MS Access 2000 subform works only once!

[Stoelting]

Hi,
I´ve got the following problem:
I have got two tables, X and Y, which are 1:n related. Y is a subtable of X. Now I made a form X´ and a subform Y´. The forms are linked via the field ID. The subform Y´ should only show the records with a respective ID, choosen in form X´. Actually, it works like I want, but unfortunately only, when the subform is implemented into the original form in a session. After closing the database and reopen it again, the subform shows ALL records indepented of their ID. After deleting the subform out of form X´and rebuilding of the subform it will work again. While that, nothing is changed in the relation of the tables and the subtable structure is still working.
Is that a failure of myself or just some of the strange MS bugs we all have to fight with?

Thanks for help,

Heiko

 

[ghubbell]

Hi Heiko,
Place the main form in design view and click once on your subform. Go to the toolbar and click on properties. These are not the subforms properties but the properties of the subform "as seen" by the main form. Find the data tab and check your two fields "Link Child Fields", Link Master Fields". These are your links from one form to another (ID no.) Make sure these are correctly "linked" and I believe your problem will be solved! Gord
ghubbell@total.net