Hello,
I'm new to this forum and fairly new to Access, Please bear with me if i'm not clear on my question..
I'm trying to create a database at work that allows users to enter information for a bi-weekly update report for their projects and it is structured like this :
ID - autonumber
Project Name - Combobox drop down from a table of projects
Reporting Date
Bi-weekly update content - Memo field with Rich Text
There is a pop up data entry (blank) form for the users to enter new update reports. Because a lot of the information in "Bi-weekly update content" gets carried over to the next report on the same project, what I need to do is in the data entry form have the "Bi-weekly update content" field auto populate with the data that's in the previous report of the same project after the user selected the project in the combobox.. I have searched online for hours but still couldn't figure it out. any advice is very much appreciated !
Thank you in advance,
Wayne