On Feb 4, 1:09*pm, John W. Vinson
wrote:
On Thu, 4 Feb 2010 05:49:55 -0800 (PST), Justin wrote:
Guess I should have tried it before I responded. I put *your code in
the Load event of the subform and it hangs up. Should this code go
into another event in addition to the load event? I copied the code
and pasted it into the event and it didn't give an error until I tried
to open the main form. The run-time error 2105 comes up saying that
"you can't go to the specified record".
Thanks again for you help.

My mistake! I didn't test it myself... *that will happen (I'm guessing) if
there are no records in the subform at all. Let me think about this and I'll
get back to you - or does anyone else have a solution handy? I know this has
been done!
--

* * * * * * *John W. Vinson [MVP]

There are already records in the subform, so I don't think that's it.
Until later, thanks.

Justin