I have two tables. In my main table I have a field named Unit (numeric field). This field is linked to another subordinate table which has Unit information in it (e.g., name of unit, phone number, commander's grade and name, etc.). I use a query linking the two tables which I use with an input form.
I created a button on the form to send e-mail (SendObject) which works fine. The e-mail is populated with various fields (Me.LName, Me.FName, Me.Action1).
The problem is that I cannot recall the name of the unit from the subordinate table (Me.Unit) into my e-mail. I can recall the numeric designator from the main table but not the text.
Do I need to provide more info than simply Me.Unit?
Any assistance would be appreciated.
I created a button on the form to send e-mail (SendObject) which works fine. The e-mail is populated with various fields (Me.LName, Me.FName, Me.Action1).
The problem is that I cannot recall the name of the unit from the subordinate table (Me.Unit) into my e-mail. I can recall the numeric designator from the main table but not the text.
Do I need to provide more info than simply Me.Unit?
Any assistance would be appreciated.
