Subform Troubles

[Neilw]

I have a form based on a query that has data from one table. On the form there is a subform which uses data from a related table (one to many relationship). My problem is: When a record is entered into the form, you have to enter a record into the subform as well or it will not show up next time you open the form. It's fairly imperative that i solve this problem though i have no idea what it causing this!!!

Any help is much appreciated!

 

[llkhoutx]

Be sure that the subform's Master Link and Child Link properties area properly set. Requery the subform each time the main form (Master Link) is modified.

 

[Neilw]

Don't see any problems there.

Any other suggestions? I'm getting desparate now, i'm supposed to be installing this for the user tomorrow!

Thanks.

 

[DBL]

In the query for the main form, do you happen to have the table for the subform in there as well? If so and it's a Show Only Records that relation to Both Tables type join that could be the problem. I wouldn't have thought you would need the other table in the query for the subform but the other way round it is to change the join type to show all from the main table and only those records that are relevant in the sub table.

Just a stab in the dark

 

[Neilw]

Thats how it is joined anyway. The subform table is in the query and i have tried taking it out before but it doesn't solve the problem. Any other suggestions?

Thanks anyway DBL.

 

[Neilw]

Would anyone consider taking a copy of my database to try and figure it out and then let me know?

Thanks,

Neil.

 

[DBL]

Send it on, no promises mind!