New record on form not inserting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I just noticed this behaviour on a couple of my forms, I think specifically
where there is data linked from another table, so maybe that could be the
source of the problem? Anyways, here is what is happening:
I click on the new record button in the navigation toolbar. I enter the
required information, and then try to click on next record, or any record
navigation button for that matter, and it does not change records. The
button depresses, but nothing happens. It also won't let me change to design
mode when I enter this new record information. When I close the form with
the 'x' at the top right of the form, then open the form back up, I confirm
that the new record was NOT inserted.
Has anybody had this situation happen to them, and can you tell me some
signs to look for to fix this?
Thanks in advance,
Dana S.
 
Hmm... Ok, I think I located the source of the problem. I hadn't inputted a
required value which did infact link it to another table. I am assuming that
is the problem with my other form. Trial and error trial and error and
success!:)
 
Dana,
I think your suspicion is right. Open the underlying
query. You may see a phrase like "not an updateable
query". It's usually because you are missing primary keys
from the other linked tables in your query.
Good luck.
Geof.
 
Back
Top