Move in a field within a subform

[dr223]

Hallo,

I have a subform called FeeDetails, which is build up of various fields, Payer_code, Session, Amount. This is build- up on a main form (StudentDetails).

I have a text box on the subform footer called txtsession1 on its control source I have =[Session]. Then I have a text box on the main form called txtsession which displays the Session from the subform.

Now, what i want to do is that there might be many sessions for one record. For example for student_ID 456745 we have 3 Sessions 2003/04, 2004/05, 2005/06. What I want to do is use a backward and forward button to be able to move towards the sessions i.e., be able to move and display on the text box on the main form 2003/04,2004/05, 2005/06 whenever the forward and backward buttons are clicked.

There are two problems here;

1) make the text box be able to understand and move from on eSession to another
2) Write a VBscript on the buttons to move forward or backward the session when clicked.


Is this possible??? Iam totally stranded......

Please could someone tell me how to do it...

Thank you

 

[ajetrumpet]

Is this a substitute for this? You may not have gotten responses because it might be too difficult. I myself don't think it's difficult, but if this is the same question, repeating from the above thread, I am still waiting for you to give an answer to the last question that was asked there. This is not difficult...