Subform ?

[Fleming]

Question: I have a form that will, in this case, track and log crime scene evidence. Often the evidence needs to be signed out and then returned and records must be kept of these transactions for court. (Chain of custody) How can I include in my form a spreadsheet or other means of showing the history of custody. When I made an additional table and inserted it into the form it would always remain and show the previous record's history. I need the form to be new with each new record. I think I need to work with a subform perhaps?

 

[Twin]

Hi,
is your additional table based on the query? I would presume that logging of the evidence is recorded on the date base in which case it could be done by setting up the query that filters out all of the movements for the evidence ID. then set up the subform that is based on that query. On the text field of the form that holds evidence ID set the property After Update to refresh object (Subform) so on each change of evidence the query would run and display current record movements.

HTH