Results 1 to 3 of 3
  1. #1
    BorisGomel is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    Apr 2011
    Posts
    101

    Link Report to Form

    Hello everybody,



    I have a small problem amd help will be greatly appreciated . I have form frmInqiureDate and two text boxes on it txtBeggining and txtEnd. Also on the form command button which execute the code to print the report rptBrowardGarn with dates typed on form in these text boxes .Everything is working well, but resently my boss asked me to put dates on the report as well .I created two text boxes txtDateBeg and txtDateEnd on report rptBrowardGarn and put like this in control of the text boxes "=frmInqiureDate!txtBeggining" and "=frmInqiureDate!txtBeggining" , but the value of dates off the form is not showing up on report.It shows "error". What Am i doing wrong here?
    Thnak you in advance for help.
    The Best Regards,
    BorisGomel

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Try

    "=Forms!frmInqiureDate.txtBeggining" and "=Forms!frmInqiureDate.txtBeggining"

    The form <frmInqiureDate> will need to be open.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    BorisGomel is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    Apr 2011
    Posts
    101

    Link Repor to Form

    Thank you very much sir!!!!

    It wokrs as I wanted it .

    Millions thanks,

    The Best Reagards!!!

    BorisGomel

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report items link to form
    By pinky33 in forum Reports
    Replies: 2
    Last Post: 04-25-2012, 11:23 AM
  2. Link from one report to another
    By jsimard in forum Reports
    Replies: 2
    Last Post: 02-29-2012, 09:14 AM
  3. Link report date with a table field
    By lizzywu in forum Reports
    Replies: 16
    Last Post: 10-27-2011, 09:51 AM
  4. Link a report to a record
    By prv in forum Reports
    Replies: 2
    Last Post: 12-14-2010, 12:45 PM
  5. Replies: 6
    Last Post: 07-21-2010, 05:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums