Subforms

[Neilw]

I have a form that takes data from a query, within this form there is a subform that takes data from a separate table.

My problem is, when an entry is made into the form, unless an entry is also made in the subform, then the record will not show up next time i open the form.

Is there a way to stop this or will i have to just put up with it??

Hope that makes sense!

Thanks.

 

[David R]

Have you checked that the form/subform are linked by the proper fields in Properties? Is the matching/linking field in the query for the main form? Is Referential Integrity checked between the two fields in the Relationships window?
All of this assumes the two are linked in some way, but given the wording of your problem, I would start there.

Of course you do not have to 'put up with it'. Even Access is a much better program than that.

Good luck, post back here if you have further troubles.
David R

 

[Neilw]

thanks guys Pat that was the case but i had removed the subform data from the query some time ago and it had no difference

 

[Neilw]

David,

This is what i did, i created a query which i based the main form on. The main form data all comes from one table as the query is just so it shows certain data according to one field. The primary key in thatt table is an autonumber - Order ID. As for the subform, the data comes from a table which has Order ID as a lookup value therefore linking the two tables.

I have done this a few times before but for some reason it wont work this time!

Does that help?

 

[Neilw]

Thanks for the suggestion Pat but the record source is still the actual query.