Thank you for your replies.
Deleting the RecordSource and then replacing it worked. It also explains why I was sometimes able to reference a field in the RecordSource and sometimes unable to reference a field.
Thanks again
I have a form bound to a query. The query result has a field that I would like to reference, however I do not want the field on my form. Is there a way to reference a field in the query results that is not on the form?
Rishi,
What is the name of your subform control?
Check out this article for info on refering to forms and Subform properties and controls.
www.mvps.org/access/forms/frm0031.htm
I am developing a database that could potentially have more than 50 reference tables with approximately 10 – 20 entries in each reference table.
I was considering combining the reference tables into one reference table, however I have never used this approach and have not been able to find any...
Does anyone know how to test for an active IP connection?
I need to connect to a remote database via IP, but I do not want to try to connect to the remote database if the PC does not have an active ip connection.
Thanks in advance.
I have been having the same problem.
I was able to get the correct counts by placing a calculated control in the group footer.
I set the Countrol Source property to =Count([fieldtocount]) and I set the Running sum property to No
I am now getting the correct counts.
I hope this works for you...