Form Display in Design View Only

[yrstruly]

My form dissapeared, when i view it in Design view its visible, but not in Form view.https://drive.google.com/file/d/1NlW...ew?usp=sharing

[CJ_London]

Is it a popup?

[yrstruly]

Is it a popup?

No, a regulr form

[CJ_London]

Due to security concerns, I'm not prepared to go to your google drive. I will only look at db's/whatever uploaded to the site - go to the advanced editor (button next to the post quick reply button). Remove or obscure any sensitive data and and any tables/queries/forms/reports/modules not relevant to your question, then compact/repair and zip the file for uploading.

You could show a screenshot of your form properties to show popup is set to no as that is the only reason I can think of where you could have this issue - unless you have code that hides/resizes/moves the form. Also be be clear whether you are using tabbed or overlapping forms.

Without more information, I will have to drop off this thread. Others may be less concerned about security so perhaps someone else will be prepared to click on your google link.

[pbaldy]

Not clicking on the link, but this may be on point:

http://allenbrowne.com/casu-20.html

[mike60smart]

Can you upload the record source of the Form?

[yrstruly]

The reason was because of the join. I do the physical join in the Database Tools Diagram section.


Original Query

SELECT DISTINCTROW TblLicence.Id, TblLicence.PlantID, Plants.Cultivar, TblLicence.Nr, Profile.Display, TblLicence.ConType, TblLicence.LicHolder, TblLicence.ConExpireDate, TblLicence.Renewable, TblLicence.Breeder, TblLicence.Upfront, TblLicence.Royalty, TblLicence.MonthPay, TblLicence.Importer, TblLicence.Comment, TblLicence.NextPeriod, TblLicence.PlantBreederRights, TblLicence.PbrExpireDate, TblLicence.Origin, TblLicence.FirstCom, TblLicence.PbrGrantNo, TblLicence.Trademark, TblLicence.FirstComPlace, TblLicence.Supplier, TblLicence.ConSignDate, TblLicence.RenewableDate, TblLicence.PBROwner, TblPlantsPrices.Royalty, TblPlantsPrices.LevyFROM ((TblLicence INNER JOIN Profile ON TblLicence.Nr = Profile.Nr) INNER JOIN Plants ON TblLicence.PlantID = Plants.PlantID) LEFT JOIN TblPlantsPrices ON TblLicence.PlantID = TblPlantsPrices.PlantID;

Altered query, which does give an output, the newly created table(TblPBRVLInfo) does not have values yet so their columns are blank:

	
	
SELECT DISTINCTROW
    TblLicence.Id,
    TblLicence.PlantID,
    Plants.Cultivar,
    TblLicence.Nr,
    Profile.Display,
    TblLicence.ConType,
    TblLicence.LicHolder,
    TblLicence.ConExpireDate,
    TblLicence.Renewable,
    TblLicence.Breeder,
    TblLicence.Upfront,
    TblLicence.Royalty,
    TblLicence.MonthPay,
    TblLicence.Importer,
    TblLicence.Comment,
    TblLicence.AnnualRenewalDuty,
    TblLicence.AnnualPBRRenewalCost,
    TblLicence.AnnualPBRRenewalRequired,
    TblLicence.NewPBRVLCost,
    TblLicence.NextPeriod,
    TblLicence.PlantBreederRights,
    TblLicence.PbrExpireDate,
    TblLicence.Origin,
    TblLicence.FirstCom,
    TblLicence.PbrGrantNo,
    TblLicence.Trademark,
    TblLicence.FirstComPlace,
    TblLicence.Supplier,
    TblLicence.ConSignDate,
    TblLicence.RenewableDate,
    TblLicence.PBROwner,
    TblPlantsPrices.Royalty   AS PriceRoyalty,
    TblPlantsPrices.Levy     AS PriceLevy,
    TblPBRVLInfo.VL_ApplicationNo,
    TblPBRVLInfo.VL_ApplicationDate,
    TblPBRVLInfo.VL_GrantApprovalNo,
    TblPBRVLInfo.VL_GrantApprovalDate,
    TblPBRVLInfo.PBR_ApplicationNo,
    TblPBRVLInfo.PBR_ApplicationDate,
    TblPBRVLInfo.PBR_GrantNo,
    TblPBRVLInfo.PBR_GrantApprovalDate,
    TblPBRVLInfo.PBR_GrantExpiryDate,
    TblPBRVLInfo.PBR_EndOfSoleRight
FROM
    (
        (
            (TblLicence
              INNER JOIN Profile
                ON TblLicence.Nr = Profile.Nr
            )
            INNER JOIN Plants
              ON TblLicence.PlantID = Plants.PlantID
        )
        LEFT JOIN TblPlantsPrices
          ON TblLicence.PlantID = TblPlantsPrices.PlantID
    )
    LEFT JOIN TblPBRVLInfo
      ON TblLicence.PlantID = TblPBRVLInfo.PlantID;

[yrstruly]

Can you upload the record source of the Form?

Its in the same MS Access i shared with you. Query QfrmLicence and Form frmLicence.

[mike60smart]

That database has long been deleted as your structure made no sense and you would not listen to any advice.