Linking Text Boxes in MS Access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • twigy
    New Member
    • Nov 2011
    • 3

    Linking Text Boxes in MS Access

    How do I link a textbox in a report to a textbox in a form so that the textbox in the report displayes the exact same value as the textbox in the form, as I want to send this report as an email because i can't do this in a form. Any help will be appreciated.
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32663

    #2
    I presume you're talking about an unbound TextBox control so it's not connected to the underlying data in any way.

    The calls to open both forms and reports include OpenArgs parameters where you can specify a value to pass to the object being opened.

    Comment

    • twigy
      New Member
      • Nov 2011
      • 3

      #3
      they are bounded by a combo box, as they are related to each other. The problem is i dont know how to to email the current record in the form, so i thought if i can pull up a report with all the same information as the form if they are linked i would be able to send the current record in an email through the report

      Comment

      • NeoPa
        Recognized Expert Moderator MVP
        • Oct 2006
        • 32663

        #4
        Originally posted by Twigy
        Twigy:
        they are bounded by a combo box, as they are related to each other.
        In as much as that makes any sense, it's impossible.

        I can only guess what you mean but if I'm right then you want to filter the report based on the value found in the control on your form (although you now seem to be implying the control is a ComboBox and no longer a TextBox). The call to open the report also has a WhereCondition parameter that allows you to specify a filter in the form of a SQL WHERE clause.

        Frankly, it's hard to help when you post responses that make so little sense. A bit more care and consideration before submitting the post would help us both enormously.

        Comment

        Working...