Form ComboBox Column Value to Table Field

[cfahy]

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?

[ketbdnetbp]

You could try setting the control source of the field to...

=[cbCriteria1].Column(1)

Assuming the score in the combo is in column 2. Note: When making a reference to a column in a combo you always start with 0 for the first column and increment up from there.

Edit: I apologize, my mistake. An easier way to do this is in the AfterUpdate Event of the combo box using VBA since you don't want to change the control source of Score1.

the code would look like:
dim x as Integer
x = Me![cbCriteria1].Column(1)
Me![Score1] = x

Sorry, evidently I'm having a distracted day.


Hope this helps,

Jim