Update table via form problem

[marathonlady]

I need to refresh my mind on something. When I try to update my 'Circuit'
table via my form, I get a message that required fields are not in the table.
I get 'Cannot insert null...into table' It is talking about trying to put a numeric ID key field that is required into the table, but since the record is not added yet the table which is oracle, doesnt have that value. How do I code this so the numeric value needed gets inserted in the table before I go to update the record?

Thanks in advance for any help.

 

[RuralGuy]

I know nothing about Oracle but I strongly suspect the error is referring to a field that you have control over and not it's own key field. It is just a suggestion but you might want to review all of your code. For example you mention problems "updating" your 'Circuit' table but the error talks about 'Cannot insert null...into table'. Are you updating or appending? Do a Debug.Print or MsgBox of all of the data being sent and see if it looks good.