Print Value from a subform

Valentine

Member
Local time
Today, 05:54
Joined
Oct 1, 2021
Messages
261
I have a subform that has 1 item in it, the Validation date of my item. On the form the subform is linked through item and displays the date properly. I have a button that I am using to send out an email but want to include the date value in the email. I cannot use Me.value because it is in the subform and not the form. How do I add that value to the email?
 
wow that was more then I expected it to be but it works now I had to do a little more work but mine looks like this:

Forms("Copy of CAPESform").[Subform Capes to Validation].Form.[Validation Date]

my main form is called "Copy of CAPESform"
Subform called "Subform Capes to Validation"
field inside the subform I am printing is called "Validation Date"
 
So? You were saying you could not use Me.Value?
That indicated to me that the code was in the mainform?
I would only use your syntax if I was trying to get a value from a subform in another open form. NOT the one I am in?

Why make it harder than it needs to be?
 

Users who are viewing this thread

Back
Top Bottom