function for navigation button caption (1 Viewer)

[leanpilar]

Hi
I need for my clients to short for month and year and 7 view per month = 84/year like in picture attached

is there a function or a code that I receive the caption or the right,2 of the navigation name without insert all manually, the function where cause work great but I have to insert all by myself
if it's possible I need to get the year(2015) in example, 01 for month and 01 for the last row...??
thanks

 

[sneuberg]

Instead of what you are doing would a date picker work for what you need. See https://www.fmsinc.com/MicrosoftAccess/Controls/components/date-picker/index.html

 

[leanpilar]

No. In the navigation where cause I have [ID] = mufunction(2015, 1, 1, forms!mainform.form.custormercodeID).
I only need if it's possible to change the 2015, 1, 1 with some function for not insert 84*5 year and 84 every year

 

[leanpilar]

solved:
I renamed the first navigation control for easy find, the 2nd and the 3rd and get the value with this code:

year= Forms!mainform.subform.Form.NavigationControlyear.SelectedTab.Caption
month= Val(Forms!mainform.subform.Form.NavigationControlmonth.SelectedTab.Caption)
line= Val(Forms!mainform.subform.Form.NavigationControlline.SelectedTab.Caption)