Results 1 to 2 of 2

Thread: Reports (97)

  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reports (97)

    Hi,
    I have a form that has a text box where the user can enter in the name of a customer. I would then like this name to be displayed on a report
    Ive played around with this a bit and im just not getting it right. I can get the customer label to appear on the report but it says error in the text box beside it. Has anybody any ideas??
    Many thx,
    Rob.
    PS Thx for the help in my previous posts

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

    Re: Reports (97)

    Is the form still open when the report is opened? If so, you can set the Control Source of a text box on the report to

    =[Forms]![frmMyForm]![txtCustomer]

    where frmMyForm is the name of the form, and txtCustomer is the name of the text box in which the user enters the name of a customer.

Posting Permissions

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