I have a form called Payroll Per Month1 in MS Access. When you open the form you have to type in the Person # and select a Month year from the drop down. This will automatically populate the form with the Account, Amount and total.
I want the form to also display the name of the user on the form which can be retrieved from the query which is attached
I also want the form to populate new data for the same user when you select a different month and year. Right now I have to start all over to accomplish that. Can you please help with that. Attached are the print screen and a copy of the table in Excel format. This is the query also for the form
SELECT DISTINCT Format([PERIOD],"mmmm yyyy") AS Expr1, DateSerial(Year([PERIOD]),
iod]),1) AS DateFrom, DateSerial(Year([PERIOD]),
FROM [Payroll Per Month]
WHERE ((([Payroll Per Month].NAME) Is Not Null))
ORDER BY DateSerial(Year([PERIOD]),