Writing to a table

[MCSGraham]

I get an error when I try to put a "1" in a field inside a table...this is the code I'm using:

Dim db As Database
Dim rst1 As Recordset
Set db = CurrentDb
Set rst1 = db.OpenRecordset("NewDB&quot

rst1.AddNew
rst1![Units] = "1"
rst1.Update

(It gives an error of "Index or Primary Key cannot contain a Null value&quot

NewDB is my table and Units is the field I want to write a "1" into.

Is there a better way to write info into a table's field?

thank you!

 

[SgtJarrow]

What is the primary key for that table??? The error is stemming from the fact that you are creating a new record, setting the Units field to 1, but you aren't setting a primary key......You code should be something like...

Dim db As Database
Dim rst1 As Recordset
Set db = CurrentDb
Set rst1 = db.OpenRecordset("NewDB&quot

rst1.AddNew
rst1![nameofprimarykey] = "somevalueforprimarykey"
rst1![Units] = "1"
rst1.Update

"As far as the laws of mathematics refer to reality, they are not certain; as far as they are certain, they do not refer to reality."--Albert Einstein

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer