bobunknown
Registered User.
- Local time
- Today, 03:01
- Joined
- May 25, 2018
- Messages
- 77
Hi all,
I have been trying to use a query with an expression as the control source for a continuous form but all I get back is the dreaded #Name?.
The query itself is, Collection Costs (individual) and im trying to use it in my Bins subform to show the total cost of a bin collection. I use the expression:
=[Collection Costs (individual)]![Cost]
I understand that this error sometimes appears when there are duplicate field names or something but I have tried a variation of changes to no avail. even deleting the text boxes on my form and re-entering them from scratch.
To save time im attaching a copy of my database so you can see what im on about. I have removed everything that isn't relevant to the problem from the DB as otherwise it would have been to large for the 2MB upload so just click OK through the error messages and hit enable content.
The section that is relevant is the lower left hand tab ladled bins that should open when it loads up.
I feel like this is a simple thing that im missing so sorry if its something stupid.
Thanks
I have been trying to use a query with an expression as the control source for a continuous form but all I get back is the dreaded #Name?.
The query itself is, Collection Costs (individual) and im trying to use it in my Bins subform to show the total cost of a bin collection. I use the expression:
=[Collection Costs (individual)]![Cost]
I understand that this error sometimes appears when there are duplicate field names or something but I have tried a variation of changes to no avail. even deleting the text boxes on my form and re-entering them from scratch.
To save time im attaching a copy of my database so you can see what im on about. I have removed everything that isn't relevant to the problem from the DB as otherwise it would have been to large for the 2MB upload so just click OK through the error messages and hit enable content.
The section that is relevant is the lower left hand tab ladled bins that should open when it loads up.
I feel like this is a simple thing that im missing so sorry if its something stupid.
Thanks