Okay this one has me puzzled and I cannot seem to find the answer online. What I am trying to do is this. In my tblStudent table I have a field called "tblStdLSSName". I also have a table called tblLSS that contains a list of names. I would like to use a multiple item form to display all the row values. Then next to each row value I have a combo box that uses the tblLSS table to populate the combo box and assign the control source to lblStdLSSName in the tblStudent table. The theory here is when a user selects a name from the dropdown that name when then replace the name in the tblStdLSSName field. The problem is when I select a different value from the dropdown box I get an error 'beep' and nothing happens. I have attached three screenshots to give you an idea of my layout.
Any ideas on why I cannot update the field value would be most appreciated.