File->Export from 2nd Form

[John Pritchard]

If I have a form that opens a second form then I've found
that File->Export always applies to the first form even
though the second form has the focus. How can I make File-

Export export the data on the second form? I tried

making a custom menu and attaching it to the second form
and the one time I got this to work Export... still
refered to the first form again even when I closed it!
I'm using Access 2000 and Windows XP and exporting data
to Excel. The second form is opened using docmd.open
etc... Thanks in anticipation for any advice.