GoTo Next Greyed Out

[Andy]

I have two tables where records are related by a many-to-many relationship so
I am using a link table to achieve this relationship and store any related
records. Fine.

I have two forms, one for each of the tables, with any related records from
the other table displayed in a subform in datasheet view in each.

When I open one of the forms it opens at the first record in the table as
expected and if I then go to Edit/Go To there are 3 options available (First,
Last and Next). Still Fine.

The problem is that if I open the other form, for the other table, once
again it opens on the first record in the table as expected but if I go to
Edit/Go To there are only 2 options available (First, Last) not the Next.

If I use the navigation button on the form I can go to the next record though.

Any thoughts?

 

[Andy]

Figured this one out.

In the form where there are only 2 options available on Go To (First, Last)
not the Next, I had the subform as the first tab position.

Once I made one of the main form fields the first tab position this fixed
the problem.