got_access:]
Registered User.
- Local time
- Today, 01:15
- Joined
- Jun 15, 2018
- Messages
- 83
Hi All,
I have a subform within a form - which I've added a calculated control (text box)
It is simply the formula avg([UnitPrice]). I've named this control "UpAverage"
But the subform is in datasheet view and displays the average prices in every row.
So I've made this control invisible.
Then in the main form I've added another control (text box) which points to that control within the subform. This now being in the main form it only displays one average value for all records in the subform.
This works great but I'm trying to understand the syntax used in the link which is either a period or an exclamation point.
The link looks like this: [frm_Subform].Form![UpAverage]
This works great - and I understand the exclamation point is a parent child link.
But I don't understand why the need for the .Form after the [frm_Subform]?
Thanks in advance
I have a subform within a form - which I've added a calculated control (text box)
It is simply the formula avg([UnitPrice]). I've named this control "UpAverage"
But the subform is in datasheet view and displays the average prices in every row.
So I've made this control invisible.
Then in the main form I've added another control (text box) which points to that control within the subform. This now being in the main form it only displays one average value for all records in the subform.
This works great but I'm trying to understand the syntax used in the link which is either a period or an exclamation point.
The link looks like this: [frm_Subform].Form![UpAverage]
This works great - and I understand the exclamation point is a parent child link.
But I don't understand why the need for the .Form after the [frm_Subform]?
Thanks in advance