Navigation Buttons on Form with Subform

[DaveTappenden]

I have a simple Form with subform, based on a query.
The navigation buttons (on the main form) reflect the number of records in the SUBFORM. (!)
For example, if the query finds one master record with 2 matching records showing in the subform, then the Nav Buttons show "Record 1 of 2" and not "Record 1 of 1"

Can anyone explain what is going on here?

Thanks
David Tappenden

 

[67peshawar294]

Hi, Not sure if this is what you mean
but if you are counting fruits, apples:

apples ((one of one))
yellow (ONE OF TWO
yellow delicious (1 of 2
granny smith (2 of 2
Red (TWO OF TWO
Mcintosh (1 of 3
Delicious (2 of 3
Fuji (3 of 3

 

[DaveTappenden]

Problem resolved thanks.
Subform was incorrectly linked to the underlying query of the main form. It should have been based on the "many" table.