I am having an odd issue. I found and adapted a calendar database I found online. It is based on a database by Peter Hibbs. I tested all of it and got it working within its own database then I imported all of the pieces in to my actual dev database.
All functions work correctly and all code compiled except for one thing. I added a function for color coding the days based on a subject. In the test database I was using before I imported the pieces into my dev database the color coding worked correctly. I have found what I think is the issue. In the attached picture you will see the query that the form is bound to. It is a whole table as well as 7 instances, for each day, of the same table that stores the category names and colors.
The form uses two controls, one with a transparent background that holds the text data and one "Bound object frame" that stores the color and is bound to each of the "tblNVHGroup.color" fields. This gives each field a color based on the category and works in the test, calendar only, database. What happens in my dev copy is that all the color fields, i.e. "day1color, day2color, etc.", cannot be changed from "tblNVHGroup.Color", I can't choose "tblNVHGroup_1.Color" for "day2color". If i select it and change it goes back to "tblNVHGroup.Color". I compared everything i can think of between the two databases and can't discern any differences that would cause something like this. The test database I used DOES allow me to select these data controls.
Any ideas why it won't let me save the correct control source.
All functions work correctly and all code compiled except for one thing. I added a function for color coding the days based on a subject. In the test database I was using before I imported the pieces into my dev database the color coding worked correctly. I have found what I think is the issue. In the attached picture you will see the query that the form is bound to. It is a whole table as well as 7 instances, for each day, of the same table that stores the category names and colors.
The form uses two controls, one with a transparent background that holds the text data and one "Bound object frame" that stores the color and is bound to each of the "tblNVHGroup.color" fields. This gives each field a color based on the category and works in the test, calendar only, database. What happens in my dev copy is that all the color fields, i.e. "day1color, day2color, etc.", cannot be changed from "tblNVHGroup.Color", I can't choose "tblNVHGroup_1.Color" for "day2color". If i select it and change it goes back to "tblNVHGroup.Color". I compared everything i can think of between the two databases and can't discern any differences that would cause something like this. The test database I used DOES allow me to select these data controls.
Any ideas why it won't let me save the correct control source.
