I am attempting to create an app for my own use that I can keep track of items purchased as well as how I rate the product in various categories. The issue I am having at this time is with the rating system. I have imported roughly 200 plus reviews I have completed so far. When the sub form loads, it correctly brings in the selected categories, but the stars show each category to be the rating of the last loaded. as you can see in the attached photo, the textbox at the end of the row is the actual rating I gave for that category, but the stars do not match. I even went further and added 5 separate Boolean fields to represent the respective star to either be on or off but am getting nowhere. I've tried several different VBA routines to attempt to change them on load. If tried, as recommend on another posting to add an IIF in the control source but it did nothing either. I'm really not sure what the issue is. This so far is primarily on the onload are and am sure I am going to have some issue later one, once I get in to the editing of the record. That will probably have something to do with referencing the row, but I will cross that bridge once I get there. I just need to get them loading correctly for now.
I am in unfamiliar territory at this point and, after all the things I have done with VBA programming, am admitting defeat. I need help and am humbling asking all you out there if there is some solution you know of or have actually done. If anyone can help with code and an explanation or links to something that address this particular issue. Any enlightenment and assistance you can give is greatly appreciated
-Chuck