Form And Subform

[mtagliaferri]

I cannot solve these 2 problems:
1 - the "sfrm1" is inserted in the "frmMain", opening the "frmMain" and then doubleclicking on the "PSR" field it will not open the "sfrm2", but if you open the "sfrm1" separetly and double clisk on the "PSR" field it would work!
I believe I have to link the forms, but I don't have a clue on how to do it.
2 - opening the "sfrm1" and doubleclicking on the PSR field it opens the "sfmr2" in a single record view but the setting of the form are as data sheet, how can this be possible?

Thanks

 

[deville75]

I'm Somewhat new to Access, but maybe I can help if I understand this a little better. What exactly is "PSR" field? I'm guessing it's within the sfrm1 form..right?

 

[Joe8915]

Is this what you are asking for see attach

 

[mtagliaferri]

No not really, what I am trying to achieve is that the final user will open the form calle FRM1 this will display the summary grouped by month of the records contained in TBL1, then if the final user want all the details of one month should double click on on record displayed under the PSR column this should open the SFRM2 showing all the recods (example 200601) in a datasheet mode as it is shown on FRM1, I can select the records if I open the SFRM1 and double clicking on on record but it wil open the SFRM2 on a single record view instead of listing them all, but if you double click on any record on the FRMMAIN it will give me a error.
Hope I have been more detailed on my explanation
Thanks to all

Marco