Record numbers correspond to subform data not form data

I have a Request form that includes/displays Requested Items in a subform,
whose parent/child relationship is based on an Autonumber.
For some reason, unknown to me, the record number displayed in the record
navigation bar for the form (not the subform) is based on all the Requested
Items in the DB not the number of Requests, as I would expect it to be.
I have other, similar forms in the same DB and they don't behave in this odd
manner and I can't see any difference in these forms in the properties of the
forms or in the table relationships that would cause this to happen.
Any help out there?

"aavila" wrote in message

I have a Request form that includes/displays Requested Items in a
subform, whose parent/child relationship is based on an Autonumber.
For some reason, unknown to me, the record number displayed in the
record navigation bar for the form (not the subform) is based on all
the Requested Items in the DB not the number of Requests, as I would
expect it to be.
I have other, similar forms in the same DB and they don't behave in
this odd manner and I can't see any difference in these forms in the
properties of the forms or in the table relationships that would
cause this to happen.
Any help out there?

Are you sure you haven't based the main form on a query that joins the
two tables? That would give you as many records as you have Requested
Items.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)