Automatic Form Update

[Confused]

Is there a way that if on a form if CustomerID has SystemID 6, then the
related Subform field [completed?] = -1

Example-Make each of the three [completed?] boxes = -1.

CustomerID SystemID
1 3
1 4
1 6

 

[John W. Vinson]

Is there a way that if on a form if CustomerID has SystemID 6, then the
related Subform field [completed?] = -1

Example-Make each of the three [completed?] boxes = -1.

CustomerID SystemID
1 3
1 4
1 6

It's easy to do it in a Table - using an Update query:

UPDATE tablename SET Completed = -1
WHERE CustomerID IN
(SELECT CustoemrID FROM anothertablename WHERE SystemID = 6);

but you said *on a form*. Forms don't store data; what's the context? Under
what circumstances do you want the Completed field set to True?