VBA not running in after update event. Run-time error '2113'

[Lifeseeker]

Hi,

I have a sample database set up in access 2007 and please see the attached.

There is VBA code behind ED_disposition field in the after update event.

When I change its value, I keep getting a run-time error "2113", saying the value you entered isn't valid for this field.

I am not sure what my problem is. Does this have to do with table level look up again?

Also, is it legitimate to write 3 if statements the way I did in the code? They are basically 3 scenario checks.

Thank you

 

[boblarson]

Change this:

Me.Ctl28_day_survival.Value = "Unsure"

to this:

Me.Ctl28_day_survival.Value = 3

because your field is numeric and the combo is bound to the ID field.