record management file pending system: open record based on query

[trixxnixon]

i have a form that is being designed to pend requests in a requests database.
the pend form is opened from an update form used by an employee to enter updates. when the pend form is updated, the tracking number of the current request is imported to the pend form, and query results are displayed at the bottom(all previous pending records for the imported tracking number)

the pend button saves either the start pending date or the end pending date.
when the start date is saved, the file is marked as pended by a check box,
when the end date is saved, the file is marked as not pended by the check box.

i need this form to manage the records based on if there is currently a pending record that is still listed as "pended" by the check box

if there is currently no record for the imported tracking number a new record will be created when the pend button is clicked.

if there is currently an open pending record(record still checked as pended) the form will populate based on the data of the open record.

if there is no open pending record the form will create a new record when the pend button is clicked.



the tracking number has a 1 to many relationship with the pending table and the pending record number is the primary key for the pending table.

Please see the screenshot i have attached if you need help understanding.