Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sub form prints blank

    Just experienced a weird one in Access 2000 using Win 2000. Unbound main form with no controls at all except for 4 sub forms (not nested).
    The 4th sub form used to be bound to a query, but it took 3 minutes to calculate &/or re-query. I altered the sub form to unbound and used Dlookups as recordsources for all text boxes (same query), result
    Regards,
    Peter

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: sub form prints blank

    If the main form is unbound, what criteria are you using for the dlookups? For that matter, what is it looking up when you run it as a main form?
    Charlotte

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sub form prints blank

    Thanks for your interest.
    sample of filling one control from the form OnOpen event
    NumWks = DSum("[Wks]", "qryClSize3a")
    BSize = DFirst("[SumOFNum]", "qryClSize3b", "[Class]='B'")
    Me![txtMeanB] = Round(BSize / NumWks, 1).
    But my main query is not why it took so long to calculate, (although I would REALLY like to know why), but why the controls print blank.
    Regards,
    Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •