Can not edit data in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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;
 
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
Click to expand...
Click to expand...
 
Thanks John will try that and let you know

John Spencer said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top