Index or primary key can't contain a Null value?

I get this runtime error when my code gets to the:

Code:

---

Data1.Recordset.Update

---

What can I do to get rid of this? Thanks :)

Did you do a .AddNew and populate the fields with data?

Yes I do. Here is the code:

Code:

---

    With Data1.Recordset
    .AddNew
    !AveragePrice = Av
    .Update
    End With

---

Thanks :)

You forgot to add the primary key field value.

You might also get an error saying invalid use of null, for the other items in your database.

Add all the items in your code and say something like for example.

VB Code:

!AveragePrice = Av & vbnullstring

To prevent any other errors