Search results

Thank you both for your responses. Mark: At this point since I am sure that we will never add other states, I'm just going to leave it. I do understand what you are saying, and will take that into consideration in the future, but to change it at this point would mean doing exactly what you...

MajP, Perhaps my response to Mark sheds more light on why I'm storing those values in the main table? I can't really get into the details of the database, but it is not a 1:1 ratio between subrecords and states. The main record has the overall information for a single "Topic". The reason I...

The problem is this data is shown on multiple forms that vary by user access-level as well as reports and I do not want to have to have it calculate over and over. Additionally, for some high-level reports, only the data from the main table is used. With the values being captured in the main...

I would have approached this differently but there are only 5 states. BUT each record could affect between 1 and 5 states. So it's not necessarily 1 state per record. (oh how easy it would be if it were) Besides a multiselect combobox (which I won't use), or a regular combobox listing every...

Mark, I'm not 100% clear on what you're asking but both the Main Record and Sub-records store State values. There's nothing that really needs to be calculated about them, they are simply checkboxes bound to a single state. The main record State boxes tell the user, at a glance, which states...

Thanks for all the responses. Yeah I'm self taught on VBA so sometimes I miss the easier solutions. MajP, what, you don't like my Rube Goldberg machine of coding? ;-) Although I've been hesitant to use Dsum and Dlookup (for performance reasons), those do seem to be a much easier solution. As...

Hi all! 1st time poster here but this site has helped me a lot through the years so thank you to everyone, especially the "regulars" So on to my issue. I have written code to loop through a continuous subform, check the value of 5 checkboxes in each record and increment a temp variable if they...