Hi its a bit hard for me to explain but if anyone could point me in the right direction as to how to do this that would be truly grateful. So basically i have made a form with the following fields PaymentID, PaymentDate, StudentID, AmountPaidSoFar, PaymentAmount, NewBalance, FullyPaid. So the PaymentID and PaymentDate are made up automatically and so will the NewBalance and FullyPaid fields. My problem lies in the middle, I have created a combo box for selecting StudentID which is using results from a query. When the student has been picked the StudentID is viewed rather than their forename and surname. I now need the text box below (AmountPaidSoFar) to show the amount they have paid individually so it needs to have some sort of link with the value in the StudentID field and the query i guess but i could be wrong. This is what i need help with, what do i use for the text box to look up AmountPaidSoFar for that specific student? (The query I can link it to has the total amount they have paid so far and all the field names i have given you are as they are in my database, so any help or examples would be good thanks)
Thanks in advance.