Forms don't work in Access 2007

[Frans Kanters]

Recently our MS Office was upgraded form XP to 2007

Now wen I open in Access 2007 my database created in Access XP I can no
longer ad reccords using forms.

I have activated macros. The problem remains after converting the database
to the 2007 format.

In the tabels in can ad records but not using forms based an those tabels.

Anywone any ideas?

 

[Tom van Stiphout]

Some reasons why you cannot add records:
* The query underlying the form is not updatable. Run it, and try to add a
record.
* The form has AllowAdditions property set to False
* There is some VBA code preventing it. Create a test form based on the same
query, without any VBA or macros.

-Tom.
Microsoft Access MVP

 

[Frans Kanters]

I found one cause

On the Property Sheet of the form
I call a macro with Event "On Dirty"

The Macro is:

Condition | Action
---------------------------------------------------|------------
[NewRecord]=True | StopMacro
MsgBox("Wijzig record?",305,"LET op!")=2 | CancelEvent


The purpose was:
to show a message if I attempt to change a record.
but when I add a new record don't show the message.

It worked fine in XP but not in 2007.
In 2007 I can't add a record; showing not any message or error.

How should I rephrase the macro?