Results 1 to 4 of 4
  1. #1
    tazzzz is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2015
    Location
    USA
    Posts
    37

    Report textbox taking value from form textbox.


    Hello all,
    First time on this forum.
    I try to have a textbox from report taking the value from a textbox in a open form.
    Textbox in report is located in "Report header" and I placed this code inside the box:
    HTML Code:
    =[Forms]![myForm]![TxtAmount].[Text]
    TxtAmount is the name of the textbox from form.
    When I open the report I get this :#error
    What should I do to fix the problem?
    Thanks for the help.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Drop the .[Text].

    Is TxtAmount also the name of a field?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I am not sure if that syntax is looking at the actual control. It may be that it is looking at the field. So maybe just ...
    =[Forms]![myForm]![TxtAmount]

  4. #4
    tazzzz is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2015
    Location
    USA
    Posts
    37
    Thank you all for the quick reply.
    The text from the form is not recorded in any kind of field. It Is used only to input text that will be used by report.
    I dropped [text] and it worked.
    What is interesting is the fact that at some point the report worked with [Text] also. As long as the report will show the value(text) from form I am fine.
    Once again, thank you all for the help.

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

Similar Threads

  1. Replies: 3
    Last Post: 12-06-2011, 07:37 AM
  2. Open report on value of textbox
    By blueraincoat in forum Reports
    Replies: 39
    Last Post: 09-21-2011, 01:53 AM
  3. Hide Report on Textbox Value
    By alyon in forum Access
    Replies: 4
    Last Post: 07-29-2011, 11:19 AM
  4. Order Report by Textbox Value
    By alyon in forum Access
    Replies: 6
    Last Post: 07-29-2011, 11:10 AM
  5. Keeping text in a report textbox
    By Hawkx1 in forum Reports
    Replies: 2
    Last Post: 11-13-2008, 04:11 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