There might be no way to modify this query to make it updatable. You have a
left join and a right join in your query. That usually make the query not updatable.
Having four tables in the query will often have the same effect?
BERTH, DDETAILS, BOATDETAILS, Owners
Can you move some of this information into a subform on the main form?
SELECT BERTH.Position, BERTH.Area, BERTH.OwnerID, BERTH.BoatReg,
Owners.Name, Owners.Address1, Owners.Address2, Owners.Address3, Owners.TelNo,
Owners.Owned1, Owners.Owned2, Owners.Owned3, Owners.Owned4, Owners.Owned5,
DDETAILS.SortCode, DDETAILS.AccountNo, DDETAILS.TransactionType,
DDETAILS.AccountName, BOATDETAILS.BoatName, BOATDETAILS.Owner1ID,
BOATDETAILS.[Owner2 ID], BOATDETAILS.[Length Ft], BOATDETAILS.[Length ins],
BOATDETAILS.[Beam FT], BOATDETAILS.[Beam ins], BOATDETAILS.InsCompany,
BOATDETAILS.PolicyNo, BOATDETAILS.ExpiryDate, BOATDETAILS.StartDate,
BOATDETAILS.[3rdPartyLib]
FROM ((Owners RIGHT JOIN BERTH ON Owners.OwnerID = BERTH.OwnerID) LEFT JOIN
DDETAILS ON BERTH.OwnerID = DDETAILS.OwnerID) INNER JOIN BOATDETAILS ON
BERTH.BoatReg = BOATDETAILS.RegNo
ORDER BY BERTH.Position;
La said:
SQL of query is as follows
SELECT BERTH.Position, BERTH.Area, BERTH.OwnerID, BERTH.BoatReg,
Owners.Name, Owners.Address1, Owners.Address2, Owners.Address3, Owners.TelNo,
Owners.Owned1, Owners.Owned2, Owners.Owned3, Owners.Owned4, Owners.Owned5,
DDETAILS.SortCode, DDETAILS.AccountNo, DDETAILS.TransactionType,
DDETAILS.AccountName, BOATDETAILS.BoatName, BOATDETAILS.Owner1ID,
BOATDETAILS.[Owner2 ID], BOATDETAILS.[Length Ft], BOATDETAILS.[Length ins],
BOATDETAILS.[Beam FT], BOATDETAILS.[Beam ins], BOATDETAILS.InsCompany,
BOATDETAILS.PolicyNo, BOATDETAILS.ExpiryDate, BOATDETAILS.StartDate,
BOATDETAILS.[3rdPartyLib]
FROM ((Owners RIGHT JOIN BERTH ON Owners.OwnerID = BERTH.OwnerID) LEFT JOIN
DDETAILS ON BERTH.OwnerID = DDETAILS.OwnerID) INNER JOIN BOATDETAILS ON
BERTH.BoatReg = BOATDETAILS.RegNo
ORDER BY BERTH.Position;
Jeff Boyce said:
You'll need to provide more information. What is the SQL of your query?
Not every query is updatable -- check Access HELP on updatable query.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Using 3 tables linked into query and form data record source is from the
query.
Cursor will go into field on form but will not allow any changes of data
