Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Minneapolis, MN, Minnesota
    Posts
    162
    Thanks
    1
    Thanked 0 Times in 0 Posts

    REPORT FORMATTING (ACCESS 2000)

    I have a report that uses a dialog form to specify criteria for the report. However, when I try to open the report the following error message comes up: "Run time error '2427': You entered an expression that has no value."
    When I click "Debug" it opens a procedure that I attached to the report on the Detail On Format event. I have attached a sample of my database. Can someone tell me what I am doing wrong? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Attached Files Attached Files
    Easy Access

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: REPORT FORMATTING (ACCESS 2000)

    The combo box in fdlgCounty has Bound Column = 1, i.e. CountyID, but the query qryCenterByCounty expects a CountyName. As a result, the query returns no records, whatever you select in the combo box. If you change the Bound Column property of the combo box to 2, it should work as intended.

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Minneapolis, MN, Minnesota
    Posts
    162
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: REPORT FORMATTING (ACCESS 2000)

    Thank you so much for your reply Hans. I guess it was just a case of not seeing the forest because of the trees. I salute you! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    Easy Access

Posting Permissions

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