Next Record command on form scrolls through all sub form records

[Donovan]

Hello Friends,

I am not the worlds greatest access user, but I'm ok. Despite this I have a frustrating problem that existed in my database in both Access 2007 and also still exists after upgrade to Access 2010. I'm sure there is a simple answer, however it is eluding me despite much fiddling

I have 2 tables in a one to many relationship.
The master table (with the primary unique key) is called MEET_HEADER
The child table with the "many" records is called MEET_AGENDA
The tables have a defined relationship linked by a field called MEET_NUMBER

When I view the MEET_HEADER table, it looks exactly as I would expect i.e. shows a single master record which can be expand to show all the link child records in the MEET_AGENDA table.

I have a form (lets call it the master form) which shows records from the master table (MEET_HEADER) and this form has a subform linked to the MEET_AGENDA table. The problem I am having is that the master from appears to have 1 record for each record in the subform, so when I try to use the Next Record or Previous Record buttons on the master form, it scrolls though all the subform records instead scrolling through the master form records, and showing any associated child records.

Any help that anyone could offer would be great. This little problem has given me an extra grey hair or two!!

Thanks, DF

[June7]

Show code or provide project for analysis. Follow instructions at bottom of my post.