Add new record in main form

[Kasher]

Hi,

I am learning access 2010. I have got one main form with three sub forms. I couldn't be able to add new record in main form as add new record option is disable, I couldn't be able to figure it out. All sub forms are working ok.

I have attached the database for a look.

thanks

 

[Mr. B]

This sound like you have used a query as the Record Source for your form and that this query is not an updatable query. If you have multiple tables included in your query you may have created a relationship between the tables that will then not let you create a new record.

Check the query to see if you can create a new record from the query. If you cannot then that is your problem.

If you have a one-to-many relationship between your tables you will need to user your form for working the the records in the primary table and create a sub-form to work with the records from the Many table.

 

[Kasher]

Thanks for your reply, actually, I am not using the query. I am using the tables. I have attached the database if you want to look at it. primary table is in the form and many tables are in the sub forms.

 

[John Big Booty]

The problem has arisen because your Main form has a Non Up-datable Record Source, as mentioned by Mr.B.