Hi all,

We are a test laboratory and have a subform where we enter the test dates. This subform looks at the parent form for the primary date and simply adds x number of days to create a future test date. For example:.

Primary Date: 01.01.2021 (Main Form)

Subform

Line 1 = 7 day = 08.01.2021

Line 2 = 14 day = 15.01.2021

Line 3 = 28 day = 29.01.2021

The code goes along the lines of 

for each line in x {

// test information, age of test and date of the test

}

However, when we need to edit a single record and go back into the form 'on edit' and amend a single entry. For instance, the client wants it testing at 28 days instead of 14, when we change the date to 28, it amends all of the records ages, test dates and loops through all the lines. It's triggering and changing all ages once we make the changes after the Primary Date. 

Is there a way for me to amend a single line in the subform and only affect that age and future test date?

Hoping someone can help

Many thanks