Have linked tables feeding a query with data from query shown on a form.
I require to be able to change or amend data from that form.
Help would be appreicated

La Durande wrote:
> Have linked tables feeding a query with data from query shown on a form.
> I require to be able to change or amend data from that form.
> Help would be appreicated

could you post the SQL? There's a good chance that resulting recordset
is not updateable. Without the SQL, it's impossible to tell.

Access Data Projects don't have random bugs like this.

Lose the training wheels. MDB is for babies.

Spit on people that use it.

-Aaron
ADP Nationalist



(E-Mail Removed) wrote:
> La Durande wrote:
> > Have linked tables feeding a query with data from query shown on a form.
> > I require to be able to change or amend data from that form.
> > Help would be appreicated
>
> could you post the SQL? There's a good chance that resulting recordset
> is not updateable. Without the SQL, it's impossible to tell.

SQL of Query is as follows:-




SELECT BOATDETAILS.RegNo, Owners.OwnerID, Owners.Name, Owners.Address1,
Owners.Address2, Owners.Address3, Owners.TelNo, Owners.Owned1, Owners.Owned2,
Owners.Owned3, Owners.Owned4, Owners.Owned5, BERTH.Position, BERTH.Area,
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, DDETAILS.SortCode,
DDETAILS.AccountNo, DDETAILS.TransactionType, DDETAILS.AccountName, *
FROM (Owners LEFT JOIN DDETAILS ON Owners.OwnerID = DDETAILS.OwnerID) RIGHT
JOIN (BOATDETAILS LEFT JOIN BERTH ON BOATDETAILS.RegNo = BERTH.BoatReg) ON
Owners.OwnerID = BOATDETAILS.Owner1ID
ORDER BY BOATDETAILS.RegNo;


"(E-Mail Removed)" wrote:

>
> La Durande wrote:
> > Have linked tables feeding a query with data from query shown on a form.
> > I require to be able to change or amend data from that form.
> > Help would be appreicated
>
> could you post the SQL? There's a good chance that resulting recordset
> is not updateable. Without the SQL, it's impossible to tell.
>
>

I would start with removing all the paranthesis on your sql statement.

that is a bug from Microsoft; and I've seen it result in AWFUL
performance out of the box.

if you MUST you can go back and add a single pair of paranthesis-- but
it's probably not necessary in 95% of the circumstances.




La Durande wrote:
> SQL of Query is as follows:-
>
>
>
>
> SELECT BOATDETAILS.RegNo, Owners.OwnerID, Owners.Name, Owners.Address1,
> Owners.Address2, Owners.Address3, Owners.TelNo, Owners.Owned1, Owners.Owned2,
> Owners.Owned3, Owners.Owned4, Owners.Owned5, BERTH.Position, BERTH.Area,
> 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, DDETAILS.SortCode,
> DDETAILS.AccountNo, DDETAILS.TransactionType, DDETAILS.AccountName, *
> FROM (Owners LEFT JOIN DDETAILS ON Owners.OwnerID = DDETAILS.OwnerID) RIGHT
> JOIN (BOATDETAILS LEFT JOIN BERTH ON BOATDETAILS.RegNo = BERTH.BoatReg) ON
> Owners.OwnerID = BOATDETAILS.Owner1ID
> ORDER BY BOATDETAILS.RegNo;
>
>
> "(E-Mail Removed)" wrote:
>
> >
> > La Durande wrote:
> > > Have linked tables feeding a query with data from query shown on a form.
> > > I require to be able to change or amend data from that form.
> > > Help would be appreicated
> >
> > could you post the SQL? There's a good chance that resulting recordset
> > is not updateable. Without the SQL, it's impossible to tell.
> >
> >