Hi,
This should be simple, but I'm pretty new to this, so I hope you can help.
I have a table (tblFeedback) with 4 fields (ID, UserName, cbCriteria1 and Score1)
I also have a form (frmFeedback) with Criteria1 as a combo box with lookup values of "yes" and "no" and score (5 for Yes, 0 for no)
I want to be able to update the field Score1 based on the combo box selection.
I thought if I create a form field and set it's Control Source to [cbCriteria1].[Column](2) it would also update the table field Score1. Not so. Can anyone give me a clue of what I'm doing wrong?