Keep old field data for report after data updated

[dlackey74]

Hi all, I hope someone can help me with an issue. I have a database with a form called "Main" where users input data and then print a report from it. "Main" has fields in it from another form "Members". This data (from "Members") is shown on "Main' by Dlookup coding, and therefore cannot be selected for input by the user. Now, lets say a user inputs data into "Main" and prints the report on 12/30/2012. On the next day, a member's name is changed and I update that data in the "Members" form. On 12/31, I would like to print the report again, but it shows the updated member's name instead of what is was like on 12/30. How can I keep the old data in case I want to print the report in the future like it was initially printed?

What do I need to do to any form(s), report or what VBA code needs to be written?

 

[khodr]

I tried my best to understand your question but if I understand you correctly I think in the required data table you need to add a field to save user name or user number and then you can create a query and call the user number or name and the required date and if there is data belongs to this user and date then it will be generated into a report to be printed

 

[DavidAtWork]

perhaps you can have a historical report table with all the report fields with additional fields to record the date/time and member's name. Each time a report is created and printed, you add a new record to this historical report table and if at some stage you want to print a historical report, you have a combo box to select the date from a list of dates which is itself dynamically running off this historical table.
David

 

[dlackey74]

Sorry been so long to respond. Thanks for the suggestions. I will try to work on it and post what results I come up with.