Master/Child results in "This expression is typed incorrectly, or it is too complex to be evaluated..."

[ARW17]

I'm trying to make the master a text box called 'TxtTab' and the child a text box from my subform: 'Forecast Date'.

I wrote some VBA code to make the 'TxtTab' text box equal the caption on my tabs. I want to be able to flip through my tabs and have the data update based on the date in the tab.

I'm not sure if I'm doing something wrong or if the way I have it set up is too complex...

 

[ARW17]

It was because I formatted the dates on the tabs with Format([], "ddd mm/yy" and it recognized this as text. I have another date at the top of my form that is formatted as a date and I set the text box to refer to it instead of to the tabs themselves.

Private Sub DayTabs_Click()
'Change Text to equal the tab in order to set Master/Child.
If DayTabs.Pages(DayTabs.Value).Name = "Today" Then
txtTab = TxtBxDate
End If
If DayTabs.Pages(DayTabs.Value).Name = "TodayPlus1" Then
txtTab = DateAdd("w", 1, [TxtBxDate])
End If
If DayTabs.Pages(DayTabs.Value).Name = "TodayPlus2" Then
txtTab = DateAdd("w", 2, [TxtBxDate])
End If
If DayTabs.Pages(DayTabs.Value).Name = "TodayPlus3" Then
txtTab = DateAdd("w", 3, [TxtBxDate])
End If
If DayTabs.Pages(DayTabs.Value).Name = "TodayPlus4" Then
txtTab = DateAdd("w", 4, [TxtBxDate])
End If
End Sub