By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,308 Members | 1,929 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,308 IT Pros & Developers. It's quick & easy.

Linking Text Boxes in MS Access

P: 3
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.
Nov 21 '11 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,707
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.
Nov 21 '11 #2

P: 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
Nov 21 '11 #3

Expert Mod 15k+
P: 31,707
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.
Nov 21 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.