Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2006
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Blank Form (2003)

    I was working on a form and trying to requery some text boxes with the code:

    Me.TxtVolume.Refresh

    After I put that into the code and went into form view the form was blank. Everything on the form is set to visible and you can see it in design view.

    I tried putting an On Open event on the form where it would set everything to visible and then I also tried switching the On Open event to Requery all of the charts. My form is still completely blank.

    If anyone can help me out with this I would greatly appreciate it.

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Blank Form (2003)

    Usually this means that there are no records in the forms recordsource.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    New Lounger
    Join Date
    Jan 2006
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Blank Form (2003)

    Wouldn't the charts show up with a blank white background? Also woudln't the labels show up?

    My form is completely blank.

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Blank Form (2003)

    If a form has there are no records in the forms recordsource then it is normal for it to show up as completely blank, so that sound sthe most likely explanation for me .

    If you take out "Me.TxtVolume.Refresh" does the problem go away?
    Regards
    John



  5. #5
    New Lounger
    Join Date
    Jan 2006
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Blank Form (2003)

    I took out the refresh and it was still blank, but I tried manually adding information into the table so the query that is the record source populates with some data and it worked.

    Once again I received great information from this website. You are a life saver. I hope you have happy holidays.

Posting Permissions

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