Null error

  • Thread starter Thread starter Mark Hubbard
  • Start date Start date
M

Mark Hubbard

I have a table joined to another table with three indexed fields. The
second table also has its primary key. I used a wizard to make a form
for the second table, and receive an error stating that a primary key
cannot be a null value when I try to enter data. However, when I use the
tables to enter data, I do not get this error. Built in help menus are
useless, I am sure I must be missing someting simple. Thanks in advance.
 
It looks like your primary key is not an autonumber. If so, your form
needs to have a piece of code in its Current event to populate the PK
before the new record can be inserted.
I'd say that Help is not useless, it is just that it is impossible to
include every detail into Help.
Good luck,
Pavel
 
Back
Top