Ok, here is the reason that I think I need to somehow change this. Everything works great, but in “tblstudents”, it shows the “gradeid” for the grade and not the grade itself. This is fine but I have to keep track of these values, but the VBA script that I am using to keep track of any changes will no give me the grade, it will only give me the “gradeid”.
I guess what I am getting at is that if I use the “gradeid” then I have to find a way to convert the number back to a grade. Therefore, I am trying to just have the combo box fill in the text box, since I know the data will be the grade itself.
I hope this makes sense.