Form to extract data from other table

[Zaigham]

Hi all, I am rather new in Access, Before this I was doing this job on Excel but due to huge data now I have converted it to Access and imported all essential information of more than 6000 pensioners including their PensionID and rate of monthly pension in a table named "Pensioners".
I just want to keep the record of monthly payments to pensioners of various Regions. Pension is being disbursed on monthly basis by 12 different Disbursing Offices.
To record monthly pension, I have created another table named "Pension Expense" having only 4 fields i.e., Month, Disb.Office, PensionerID, MonthlyPension.
Is there any way to create a form who snatch data from "Pensioners" table and enter the data in "Pension Expense" table by allowing me to change the amount of monthly pension if needed. To avoid repeated typing, it is also needed that default value in field "Month" should based on last record as it would be changed every month.

Regards
Zaigham

 

[alansidman]

You might want to try and use sub form convention. Here is a tutorial on sub forms that may be helpful

Created by Camtasia Studio 2

 

[Zaigham]

You might want to try and use sub form convention. Here is a tutorial on sub forms that may be helpful

Created by Camtasia Studio 2

Thank you very much Alan Sidman.