Question New Record Button Disabled

[naveedmazhar]

Hello,

In one of my Access Form, the button for adding new record is disabled. In other words, I cannot add new record through form.

What is the reason behind it?

Bye,

 

[MStef]

In ALLOW ADDITIONS properties put YES.

 

[naveedmazhar]

In ALLOW ADDITIONS properties put YES.

It is already set to YES. I don't know what is wrong with it.

 

[MStef]

Maybe there is in VBA set this properties on NO, check VBA in this form.

 

[naveedmazhar]

Maybe there is in VBA set this properties on NO, check VBA in this form.

I also checked the VBA, but here also the AllowAddition is set to true.

 

[MStef]

Send me a short example of your mdb (this form and table), Access 2000 or 2002.

 

[naveedmazhar]

Send me a short example of your mdb (this form and table), Access 2000 or 2002.

The form is already developed by other person and it is not allowed to give that form because it has confidential matter on it.

I am checking it by adding New Record Button from the Toolbox. Let's see what happens?

Thanks for your quick replies.

 

[naveedmazhar]

The form is already developed by other person and it is not allowed to give that form because it has confidential matter on it.

I am checking it by adding New Record Button from the Toolbox. Let's see what happens?

Thanks for your quick replies.

I used the Add New Record Button but it gave the following message:

"You cannot go to the specified record."

 

[maxmangion]

The form is already developed by other person and it is not allowed to give that form because it has confidential matter on it.

You should check with this other person as probably he disabled the button on purpose until some criteria is met to enable it.

 

[naveedmazhar]

You should check with this other person as probably he disabled the button on purpose until some criteria is met to enable it.

I think that there is some data missing in last record that's why it is behaving like this. In that form, there are too many fields and data is coming from multiple tables.

I think that corrupt data in any record prevents it to add new record.