How Subform only to show fields with records ?

[David Allison]

How is the Subform made only to show fields with records witch relate to the
parent record?

Also how to stop Subform Input new record row - from showing ?

Thanks

 

[Scott McDaniel]

You set the Master and Child link values to the appropriate fields. These
would be the fields that relate your two datasources (usually a table or
query). Access will handle the rest for you. To not show the new record row,
set AllowAdditions to False in Design view.

 

[David Allison]

Works a treat ! -- Dave Allison ~ Scotland

You set the Master and Child link values to the appropriate fields. These
would be the fields that relate your two datasources (usually a table or
query). Access will handle the rest for you. To not show the new record row,
set AllowAdditions to False in Design view.