Automatically change field on main form based on information from subform

[TB11]

Hi.

I have a continuous subform that includes IDNote, DateNote, TimeNote.
There may be just 1 note, or there may be many notes.

Is there a way to automatically change the IsGroup field on main form when there are 2 or more notes added to the subform? Or is this a separate update query?

And while I am at it, is there a way to count the number of notes just for the particular subform and pass that value to the main form?

Thanks.

 

[June7]

Calculate this value, don't save into table. Have a textbox in subform footer that calculates count of records: =Count(*). Unbound checkbox on main form references the textbox: =IIf(subformContainerName.Form.textboxName>1, True, False)

 

[TB11]

@June7 Thanks.