Linking Forms

[Guest]

Hello,
I have main form that displays weekly data and a subform within the main
form that displays monthly data. I have a button on this same form that opens
another form (PTD form) that displays period to date detail.
I want the PTD form to open to the same month that is displayed on the main
form. Currently my PTD form has 12 records (1 for each month) and opens in
alphabetical order. The form uses a query to pull data.
I can link the months in the query, however when the PTD form opens it only
displays the current month. I need the PTD form to open to the month
selected, but still give the user the ability to look at other months.
Any ideas?
Thanks,

 

[Guest]

Make the PTD form based on a query that selects all records and orders them
by month. When you call up this form, use the GoToRecord action to position
it at the proper record num, determined from the other form.