Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Location
    Kansas City, MO
    Posts
    17

    Question Unanswered: Access 2000 Forms Coding

    Please advise how to send data from a form to a report. What type of form control expression do I need to write??? I am using Access 2000.
    I have the same field names in each the form and report. They are both coming from the same table... But when I type in the form and examine the report the field I typed in is blank . What is wrong??

    Thanks
    Karol
    Karol

  2. #2
    Join Date
    Apr 2002
    Location
    Portugal
    Posts
    146

    Smile

    Hello Karol!

    See if this works:

    In your report, set the control source property to:
    =Forms![Your Form Name]![Your form's control name]
    if isn't working try
    =Forms![Your Form Name].[Your form's control name]

    Note that when you preview or print the report, the form must be open.

    hope this can help you!
    Last edited by Miguel; 04-12-02 at 23:08.

Posting Permissions

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