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

**jltl** · Aug 3rd, 2005, 12:30 AM

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

**RobDog888** · Aug 3rd, 2005, 12:31 AM

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

**jltl** · Aug 3rd, 2005, 01:06 AM

Yes I do. Here is the code:

Code:

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

Thanks

**Pradeep1210** · Aug 3rd, 2005, 01:26 AM

You forgot to add the primary key field value.

**snipered** · Aug 3rd, 2005, 02:08 AM

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

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

Thread Tools

Display

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

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

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

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

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

Posting Permissions