Remove Static Reference On Report

[yrstruly]

I want to remove this reference, Plants_1.Cultivar from the form, but cant seem to remove it.
I updated my code :

SELECT tblNursOrders.Nr, Profile.Display, tblNursOrders.Anno, Plants_1.Cultivar, Plants_1.Clone, tblNursOrders.PlantIDRoot, Plants.Cultivar, Plants.Clone, tblNursOrders.PlantIDScion, tblNursOrders.OrderAmount, tblNursOrders.OrderBy, tblNursOrders.Allocated, tblNursOrders.Contract, tblNursOrders.Comment, tblNursOrders.SourceRoot, tblNursOrders.Cerified, tblNursOrders.CertifiedType, tblNursOrders.DeliveryNo, tblNursOrders.DeliveryDate, tblNursOrders.DeliveryQuantity, Profile.Initials, Profile.Surname, Profile.Address, Profile.Town, Profile.Country, Profile.PostCode, Profile.CertNo, tblNursOrders.OrderSize, tblNursOrders.DeliverySizes, tblNursOrders.DeliveryNotePrinted, tblEntToPay.PayTo, tblNursOrders.DeliveryType, tblEntToPay.VatNo, tblNursOrders.SourceScion, tblEntToPay.FinRekNo, tblEntToPay.Vat_103_Received, tblEntToPay.Exemption_from_VAT, Profile.Conditions_of_Sale, tblNursOrders.Nursery, tblEntToPay.VATIDFROM (((Profile INNER JOIN tblNursOrders ON Profile.Nr = tblNursOrders.Nr) INNER JOIN Plants ON tblNursOrders.PlantIDRoot = Plants.PlantID) INNER JOIN Plants AS Plants_1 ON tblNursOrders.PlantIDScion = Plants_1.PlantID) LEFT JOIN tblEntToPay ON tblNursOrders.PayableTo = tblEntToPay.VATID
WHERE (((tblNursOrders.DeliveryNo)=[Forms]![FrmPrintDeliveryNotesNurs]![Text1]))
ORDER BY Plants_1.Cultivar, Plants_1.Clone, tblNursOrders.PlantIDRoot;

To:

SELECT DISTINCT
    N.Nr,
    P.Display,
    N.Anno,
    Plants_1.Cultivar      AS ScionCultivar,
    Plants_1.Clone         AS ScionClone,
    Plants.Cultivar        AS RootCultivar,
    Plants.Clone           AS RootClone,
    N.PlantIDRoot,
    N.PlantIDScion,
    N.OrderAmount,
    N.OrderSize,
    N.OrderBy,
    N.Allocated,
    N.TreePrice,
    N.Contract,
    N.Comment,
    N.SourceRoot,
    N.Cerified,
    N.CertifiedType,
    N.DeliveryNo,
    N.DeliveryDate,
    N.DeliveryQuantity,
    N.DeliverySizes,
    N.DeliveryNotePrinted,
    P.Initials,
    P.Surname,
    P.Address,
    P.Town,
    P.Country,
    P.PostCode,
    P.CertNo,
    P.Conditions_of_Sale,
    E.PayTo,
    N.DeliveryType,
    E.VatNo,
    E.FinRekNo,
    E.Vat_103_Received,
    E.Exemption_from_VAT,
    N.Nursery,
    E.VATID,
    Format(Nz(N.Allocated,0)*Nz(N.TreePrice,0),"Currency")          AS [Total Tree Cost],
    Format(Nz(N.Allocated,0)*Nz(ScionPP.[Royalty/Levy],0),"Currency") AS [Total Scion Royalty],
    Format(Nz(N.Allocated,0)*Nz(RootPP.[Royalty/Levy],0),"Currency")  AS [Total Root Royalty]
FROM
    (((((tblNursOrders AS N
        INNER JOIN Plants 
          ON N.PlantIDRoot  = Plants.PlantID)
       INNER JOIN Plants AS Plants_1 
          ON N.PlantIDScion = Plants_1.PlantID)
      LEFT JOIN Profile        AS P  ON P.Nr        = N.Nr)
     LEFT JOIN tblEntToPay     AS E  ON N.PayableTo = E.VATID)
    LEFT JOIN TblPlantsPrices AS RootPP ON N.PlantIDRoot  = RootPP.PlantID)
    LEFT JOIN TblPlantsPrices AS ScionPP ON N.PlantIDScion = ScionPP.PlantID
WHERE
    N.DeliveryNo = [Forms]![FrmPrintDeliveryNotesNurs]![Text1]
ORDER BY
    Plants_1.Cultivar,
    Plants_1.Clone,
    N.PlantIDRoot;

I deleted all boxes from the report. It still refeence that Plants_1.Cultivar. What am i missing?

[Welshgasman]

One moment it is a form, then a report , which is it ?

Search for the fieldname in whatever object it actually is.

Failing that, upload the DB with enough to see the issue and explicit instructions on how to recreate the issue.

[yrstruly]

I did not ask for a sarcastic response, so your comment is unnecessary. This is a forum for asking questions—those who wish to reply are welcome to do so.

One moment it is a form, then a report , which is it ?

Search for the fieldname in whatever object it actually is.

Failing that, upload the DB with enough to see the issue and explicit instructions on how to recreate the issue.

[Welshgasman]

Ah, now I remember you.

[mike60smart]

Will always remember yrstruly. Will not accept what you tell him. Just does his own thing.

[Minty]

I'll bite.
When you say remove the reference, what do you actually mean, as it's still in the underlying query although it's aliased?
Is the form/report asking for it like a parameter?

And the question about it being a form or report is relevant, as there is no point having a sort order specified in the query if this a report's record source, it will be completely ignored.