Robin
Glad I could help. I've stumbled across this before. One thing that will make it more evident next time is if you have your Options>Object designers>error checking turned on. The control should show a little flag (default is bright green) in the corner of the control indicating an error. Click on the pop-up and you will see the "Circular Reference" error pop up.
Also, make it a practice that whenever you use an expression as a ControlSource that you use a naming convention to name the control. Wizards and such will simply use the field name which is usually okay, but can cause unexpected problems.
-Bill
---In MS_Access_Professionals@yahoogroups.com, <robinski@westnet.com.au> wrote :
G'day Bill,
Absolutely brilliant! I would not have thought of that in 1000 years!
Many thanks,
Robin Chapple
At 27/01/2015 02:32 AM, you wrote:
I bet I know what's wrong. The control is probably named YearStart. That creates a circular reference. Change the name of the control to something like txtYearStart.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar