Automatically change field on main form based on information from subform (1 Viewer)

TB11

Member
Local time
Today, 08:56
Joined
Jul 7, 2020
Messages
54
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

AWF VIP
Local time
Today, 05:56
Joined
Mar 9, 2014
Messages
3,882
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)
 

Users who are viewing this thread

Top Bottom