Subform fail to update

[Perfac]

I am probably missing something obvious. Table t01RaltiveSub, query q01RelativeSub, form f01RelativeSub. In form f01Employee, form f01RelativeSub is added as a Subbform. Foreign key employ_ID07 in f02RelativeSub joining with employID in t01Employee.

The problem is that even though queries q01RelativeSub and q01Employee is updatable. The subform inside the form does not allow updates. We recently set On Load additions to false but I even took that out.

[CJ_London]

check the subform form properties - if you previously used on load to set allowadditions to false and subsequently saved the form, it will have saved with that setting

[Perfac]

I removed the VBA that set Allow additions and delete to false, and set it to be on. We make backups everyday. On the backup of two days ago it worked and still works. I don't know what happened for it not to work any more. I recreated the table, query and form and still, no solution yet.

[CJ_London]

what is the sql to the subform recordsource

[isladogs]

Long shot. Check whether the Boolean field used for your checkbox has a default value. If not, add as true or false as preferred.

Failing that, please provide the SQL for both forms.

BTW I hope the data shown isn't real.

EDIT Ajax got there first

[Perfac]

Data is not real. SQL for two queries. q01Employee and q01Realtive Sub. I will try to attach the database.

SELECT t01Employee.EmployID, t01CombinedEntity.EntityName01 AS EmployeeName01, t01Employee.EmployeeNum01, t01Employee.Addrss_ID06, t01Employee.BnkPrt_ID05, t01Employee.BusPol_ID03, t01Employee.SalPrc_ID01, t01Employee.JobTit_ID03, t01Employee.Langge_ID01, t01Employee.Nation_ID01, t01Employee.Qualif_ID01, t01Employee.MarSta_ID01, t01Employee.RetRes_ID01, t01Employee.NamesOnId, t01Employee.NameCalled, t01Employee.IDNumber01, t01Employee.CelPhnNum01, t01Employee.LandlineNum01, t01Employee.EmlAdr06, t01Employee.UserName02, t01Employee.Password02, t01Employee.DateOfBirth01, t01Employee.StartDate03, t01Employee.DateLeft1, t01Employee.DateLeft2, t01Employee.DateLeft3, t01Employee.SalaryType, t01Employee.EmploymentStatus02, t01Employee.TaxNumber01, t01Employee.MedicalAid01, t01Employee.PensionFund01, t01Employee.Chkpst05, t01Employee.NumOfChildren, t01Employee.OtherDeduct, t01CombinedEntity.CmbEntID, t01CombinedEntity.EntTpe_ID01, t01CombinedEntity.LdgAcc_ID01, t01CombinedEntity.VatRte_ID02, t01CombinedEntity.EntityName01, t01CombinedEntity.Check011, t01CombinedEntity.Logo01, t01CombinedEntity.Photos01, t01CombinedEntity.Documents01, q01Address.AddrssID, q01Address.PstCdePO_ID, q01Address.PstCdeST_ID, q01Address.POBoxNum, q01Address.StreetNumber, q01Address.StreetName, q01Address.BuildingName, q01Address.RoomNumber, q01Address.PPstCde, q01Address.PSuburb, q01Address.PCity, q01Address.PProvince, q01Address.SPstCde, q01Address.SSuburb, q01Address.SCity, q01Address.SProvince, t01BankParticulars.BnkPrtID, t01BankParticulars.BnkBrc_ID, t01BankParticulars.AccTpe_ID01, t01BankParticulars.AccountName, t01BankParticulars.AccountNum, q04BankBranch01.BnkBrcID, q04BankBranch01.BnkBrcNum, q04BankBranch01.Bnk_ID01, q04BankBranch01.BranchName02, q04BankBranch01.BranchCode01, q04BankBranch01.BankName02
FROM (((t01CombinedEntity INNER JOIN t01Employee ON t01CombinedEntity.CmbEntID = t01Employee.EmployID) INNER JOIN q01Address ON t01Employee.Addrss_ID06 = q01Address.AddrssID) INNER JOIN t01BankParticulars ON t01Employee.BnkPrt_ID05 = t01BankParticulars.BnkPrtID) INNER JOIN q04BankBranch01 ON t01BankParticulars.BnkBrc_ID = q04BankBranch01.BnkBrcID;


SELECT t01RelativeSub.ReltveID, t01RelativeSub.Relatn_ID01, t01RelativeSub.Employ_ID07, t01RelativeSub.NameSurname01, t01RelativeSub.PhoneNum07, t01RelativeSub.EmlAdr08, t01RelativeSub.WorkPhoneNum01
FROM t01RelativeSub;

[CJ_London]

I'd be surprised if the first query is updatable - too many joins and referencing other queries. Would need to check but if the main form is not updateable, that property would be passed to the subform. You might also check the main form properties as well

[Perfac]

Frustrating when solutions happens this way, but I recreated t01Employee and q01Employee, so the subform f01RelativeSub updates in f01Employee, and working perfect, even though I don't know why the problem occurred initially. I also store information of cutomers's RELATIVES. So the same table is used to create query q01RelativeSubCus. In f01Customers I therefore attach f01RelativeSubCus. The master and child links have to be right because the correct data display. I still try to find out why f01Employee mainform and f01RelativeSubEmp works successful, but not f01Customer mainform and f01RelativeSubCus.

Is it possibly to do with the 2 queries using the same table as source?

[CJ_London]

Is it possibly to do with the 2 queries using the same table as source?

I don't see why not