Problem adding new record in form view

[Guest]

Hi there,

I have inherited an acccess database and have had to do some troubleshooting
on an error message which is now sorted out.

I now am unable to add a new record in form view, however if I enter the
information directly into the table there is no problem.

Please could you help with what might be going wrong?
Thanks

 

[Jeff Boyce]

Open the form in design view. Open the properties window for the form. Is
the Allow Additions property set to yes?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Hi Jeff,

Yes, it is set to 'Yes'

 

[Jeff Boyce]

Since you mentioned the trouble-shooting and error message, and seemed to
connect them with the new issue, what were they about?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

The error message was; "the value you entered isn't valid for this field". I
had to cheat to get this to work, so the two may be related. I had to take
an earlier copy of the database and export the object into the newer version.
One of the fields still doesn't work but at least I don't get the error
message any longer.

I have manipulated a query to get the data into a report that I need so this
is only a cosmetic issue now ( I think!)

Does it matter that Data Entry is set to NO on the Form properties though?

 

[Jeff Boyce]

That could do it! Check Access HELP on that property...

Regards

Jeff Boyce
Microsoft Office/Access MVP