Can not add records through form/subform interface

[ajentp]

My database is not letting me to add new records through Form/2 sub form interface. I am using several tables with 1 to many relationships.

Any help is much much appreciated. File is attached.

Big Thank You.

 

[missinglinq]

The query that is the Record Source for your main form, generated, I'm guessing, using a Wizard, can not be updated. Since you give no information as to what you're actually trying to do here, it's impossible to give any advice on how you should proceed.

Here is a link to one of the best explanations available as to why queries cannot be updated; perhaps it will be of help to you:

http://allenbrowne.com/ser-61.html

 

[ajentp]

The query that is the Record Source for your main form, generated, I'm guessing, using a Wizard, can not be updated. Since you give no information as to what you're actually trying to do here, it's impossible to give any advice on how you should proceed.

Here is a link to one of the best explanations available as to why queries cannot be updated; perhaps it will be of help to you:

http://allenbrowne.com/ser-61.html

Thank you for reply. I found out that due to relationship constraints, the data was not being updated. I change the structure and add two Combo boxes. Now it is working fine and I can update the data.

Sorry for not being clear about my question.

Thank you

 

[missinglinq]

Glad you got it working!