G
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,
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,