Field Cannot be updated - Error

[aamer]

I created a form (Salery) and subform (Employee being the subform) and when I try to enter information into the Employee subform, I get the error "field cannot be updated." However, after I click "ok", I can then enter information into the subform. How do I get rid of that error message?




Name Of Query: Query1
Query on Salery Form
SELECT Company.ComapnyName, Company.CoId, Company.Dept, Company.Catagory, Company.CoAttach, Company.[NIC No]
FROM Company
ORDER BY Company.ComapnyName;

Name Of Query: Main Salery Query
Query on Employee subform
SELECT Purchases.PurTransId, Purchases.[Purchase Date], Purchases.[Pur Seller], Purchases.[Purchased from Company], Purchases.Warehouse, Purchases.[Purchase Description], Purchases.[Salery Month], Purchases.[Purchase Qty], Purchases.[Purchase Units], Purchases.[Purchase Price], [Purchase Price]*[Purchase Qty] AS totlAmt, Purchases.[Purchase Type], Purchases.purattach, Purchases.[Pur Entry Type], Purchases.[Pur User], Purchases.[EntryPLogin By], Purchases.[Pur Varification], Purchases.[Purchase Remarks], Purchases.CatPurchase, Purchases.PurCompanyName, Purchases.[Payment Made], Purchases.[Invoice #], Purchases.[Truck #], Purchases.[Payment Type], Purchases.[Supplier Bank], Purchases.[Delivered To Party], Purchases.PurCoId
FROM Purchases
WHERE (((Purchases.CatPurchase)="KatSalery"));

[June7]

How are main and sub forms related? What are the Master/Child properties of the subform container set to?

If you want to provide db for analysis, follow instructions at bottom of my post.

[aamer]

Mater Fields: CoId;ComapnyName
Child Fields: PurCoId;PurCompanyName

[June7]

Why include the name fields in the links? The ID fields should be enough.

[aamer]

Even If I remove name fields still I am getting error

[aamer]

Query1





Main Salery Querry

[A S MANN]

What is relationship between these two table?
Try use Company table as Source for form and Purchase Table as Child as sub form.

[June7]

You have CompanyName set as primary key. Should be CoID.

[aamer]

Have changed CoID as primary key.
problem still not solved

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

[John_G]

Do you have any VBA code in these forms? It may be that code that is causing the error, and not the forms themselves.

John

[aamer]

June I have attached DB for analysis
Problem is in Salery Data Entry Form
Whereas Salery Payments Entry Form is working fine

Final Sample.zip

[June7]

The db provided still has company name as primary key and compound links on subform. DB is set up to save company name to related tables and should be saving only the company ID. Example: Purchases table has a text field PurCompanyName and a number field for PurCoID. Remove PurCompanyName field. Fix or remove the link in the Relationships window. Fix the form/subform links.

I don't understand the data structure. Salaries are in Purchases?

There is no [Salery Data Entry Form], there is [Salery Entry Form] and [Salery]. Appears to be two sets of form/subform.

Fix and clean up db then post for analysis if you need more help.

I see numerous misspellings in the db (Salary is one).

[John_G]

Hi -

Found it. On the sub-form "Salary Subform", you have the default value for the "Total Amount" control set to 0. In the query, "Total Amount" is a calculated field, and cannot be updated, which is what the default value setting tries to do when it creates a new record.

Delete the default value setting for that form control, and the error goes away.

There are other issues with this database, but the default value was the cause for the error.

John

[aamer]

Thank u John
problem solved.

Yes there are numerous issues with this DB. But as long as its doing my job its fine.
its like asking a kindergarten student to write the thesis.

I studied computers in 1983. when we used to have apple IIE. after that what I did, did it on my own picking something from here and some thing from there.
By profession am not into computers, only do it for my passion. Regarding spelling mistakes as june pointed out. English is not my language, I believe as long as the communication is done or is understood. all is ok.


thx once again to u and june for the help.