Forum Discussion

DevilDawg's avatar
DevilDawg
Copper Contributor
Jan 13, 2023

Rating system problem

To start out with, this form is used to rate things using a five-star method. I have a combo box that a user can select a category on which they wish to rate the transaction on. Once they select one and decide to add it, I have VBA that adds that selected category to the database and requeries a subform. The subform is linked to the overall record. The entry is listed in the subform and has 5 empty stars and the user can click on the star and it, as well as the previous stars, get replaced with a filled star. The images are merely placeholders and the actual rating, 1 to 5, is stored as an integer. Everything works to this point.

 

My issue is, when the user tries to select a star, all the ratings for all the other categories are also mirrored. I am sure it is something very simple I am overlooking but I just can't put my finger on the issue. As the 5 placeholders are individually named but duplicated for each record, my code does not know specifically which entry it should stick to.

 

Can anyone help me on this; point me to a tutorial online or help anything to help rattle my brain

 

My continuous form looks like :

This is subform in the actual form with the Rating category combobox. The Overall Rating works like it should.

 

Any help and guidance is greatly appriciated

No RepliesBe the first to reply

Resources