Populate record based on similar record

[JLV]

I'm trying to populate a record based on a similar record in the same
table/form. I created a query that looks up the record I'd like to populate
into the form, but I can't for the life of me figure out how to get it there.


For some additional background info, the database is working with daily
alerts of infection clusters at a hospital. The database users fill out a
survey for each day there is an alert; multiple alerts over multpile days for
the same organism create a cluster. Therefore, if the user fills out the
survey on Monday for cluster X and gets an alert on Wednesday for the same
cluster, I would like there to be a button that will fill in the survey with
the previous day's responses.

Thank you in advance for your help!

 

[Jackie L]

If you already have a query with the record, change it to an Append query and
pick the table you want to add the record to.

Hope this helps,
Jackie