Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    #Name? (Access 2000)

    This is very confusing to me. We have a report that is used to map out time input for projects. Anyway, before you go to the report you get a form that pops up asking you to fill in the date you want to begin. After the date is entered they click a command button and the report generates. It looks great, there are five date boxes. After the first they are sequential. The problem is when we want to print it. In those particular fields we get #Name?. The control source for each one is =[Forms]![Date Input frm]![datein], the second =[Forms]![Date Input frm]![datein]+1, the third =[Forms]![Date Input frm]![datein]=3 and so on. Any help is greatly appreciated.
    Thanks................Kristen

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: #Name? (Access 2000)

    Same question as in a previous post:
    Is the forms still open, or is it closed as the print command button is clicked ?
    Francois

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

    Re: #Name? (Access 2000)

    Why don't you simply store the datein value in an unbound textbox. Then you can refer to that textbox (which always holds its value since it's unbound) and change your formula to =[txtDateIn], =[txtDateIn]+1, =[txtDateIn]+2, etc.
    Charlotte

Posting Permissions

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