Run time error 2113 - the value you entered isn't valid for this field (1 Viewer)

[Niyiomojoh]

I downloaded an MS Access Inventory template. In the inventory table I added a row - "Unit Cost"
I also created tables for customer and sales (this has Unit cost also)
I decided to do an auto-fill to fill the sales form. But it keeps throwing error 2113 - for the field. I tried to debug but couldn't get the issue. But it allows value to be typed in without showing error.

I need a solution. Somebody help!!

 

[theDBguy]

Hi. We'll need to see the code you're using to get an idea what may be going wrong with it.

 

[Niyiomojoh]

The code is

Private Sub cboProduct_Change()
Me.txtCategory.Value = Me.cboProduct.Column(1)
Me.NumUnit_Cost.Value = Me.cboProduct.Column(2)


End Sub

 

[Niyiomojoh]

The zip is attached herewith.

I dearly need a helping help for the academic project