Auto-populate data entry form field with previous data

[waiflam]

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

[pbaldy]

How about this in the after update event of that control?

http://access.mvps.org/access/forms/frm0012.htm

[waiflam]

Thank you Paul,
looks like the code would bring data just entered and carry it to the next new record. however what my situation require is that it pulls data already entered previously according to the Project selected by the user.

Example: records already in database
Project A - Feb 20 2015 - No Update
Project B - Feb 19 2015 - Lots of Work
Project C - Feb 13 2015 - Stable
Project C - Feb 23 2015 - Over Budget

When the user click enter new data, a blank data entry form pops up, user select Project C from the combo box, the Update box would show as "Over budget" and if user select Project A, "No Update" will show up automatically without anything just being entered. is it possible ?


Thanks a bunch

[pbaldy]

Try creating the queries here:

http://www.baldyweb.com/LastValue.htm

so you have a query that gets the last status for each project. Then you can use a DLookup() to get the last status from that and put it on the form.