Form Open

[alpapak via AccessMonster.com]

Form Open
------------------------------------------------------------------------------
--

hi
i have a form (Datasheet View)
FrmPay
PayYear
Qtr1
Qtr2
Qtr3
....
Qtr12
SumQtr

the PayYear is show me the Year , the Qtr is refer to each month (Qtr1 = Ian ,
Qtr2 = Feb, ...) and show me the money of that month.

example
PayYear Qtr1 Qtr2 Qtr3 Qtr4 ... Qtr12 SumQtr
2006 500 400 700 200 300 3500
2005 400 300 600 500 200 4200

I want to DoubleClick at Qtr1 and open a form(FrmDetailPay) which will show
me details of that month
My problem is how to get the PayYear and the Month
example: i doubleclick Qtr1 at the year 2006 and i want to see details for
ianuary 2006

i know it is

DoCmd.OpenForm "FrmDetailPay",....

 

[Guest]

What kind of form is summary data you are showing? What kind of controls
are showing the Pay Year? How are the text boxes with the summary datat
named?