Solved Getting Data from a Subform to use in a button (1 Viewer)

[martincabrera33]

Hello,
I have a similar question regarding yesterday, but this time is in a different form.
I have a form, that has a subform, and I am adding a button to the form that is getting data from the subform

@arnelgp Yesterday you taught me to use
format(Me!DateTextbox, "yyyy_mmm_dd")
To get the date of a field.

But on a subform I cant make it work.

Forms![Form].[Subform].Form![format(Me!DateTextbox, "yyyy")]

But it doesnt work. Not sure how to pull the format just to show me the year, currently if I do something like:

Forms![Form].[Subform].Form![DateTextbox]

This actually work, but not sure how to get just the year.

If somebody can help me it would be awesome.

Attached is the error I get

Thanks,

 

[pbaldy]

Try

format(Forms![Form].[Subform].Form![DateTextbox], "yyyy_mmm_dd")

 

[arnelgp]

use:

Year(Forms![Form].[Subform].Form![DateTextbox])

 

[martincabrera33]

Try

format(Forms![Form].[Subform].Form![DateTextbox], "yyyy_mmm_dd")

It worked!

 

[martincabrera33]

use:

Year(Forms![Form].[Subform].Form![DateTextbox])

This also works, I'll use this one because it is less code and easier, provides better readability, thank you to both!