SubForm Not Showing Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BevC. - 02 Jul 2007 17:42 GMT

I have a form with subforms and one of the forms does not show all of the
data. It shows some of the records, but other records drop out for no
apparent reason. Can you help me?

Reply to this Message

Bob Quintal - 02 Jul 2007 17:18 GMT

=?Utf-8?B?QmV2Qy4=?= <BevC@discussions.microsoft.com> wrote in
news:79B2DC17-AA34-4C7F-954B-9B6477250D82@microsoft.com:

> I have a form with subforms and one of the forms does not show
> all of the data. It shows some of the records, but other
> records drop out for no apparent reason. Can you help me?

Nobody van help you unless you provide some meaningful information
about your context, such as the query used for the main form, the
query used for the subform, the subform control's the link parrent
fields, link child fields, etc.

Signature

Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message

SteveM - 02 Jul 2007 19:32 GMT

Check the Master/Childlinks in your subform's properties.

I have seen this before when this property contains multiple field links.
Some records may only match one field when both (or more) are required to
satisfy the link.

Steve

> I have a form with subforms and one of the forms does not show all of the
> data. It shows some of the records, but other records drop out for no
> apparent reason. Can you help me?

Reply to this Message