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.
Linking Text Boxes in MS Access
Collapse
X
-
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. -
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 reportComment
-
In as much as that makes any sense, it's impossible.Originally posted by TwigyTwigy:
they are bounded by a combo box, as they are related to each other.
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
Comment