Can someone tell me why the top (first) line of syntax works from a list, but the second line from a label does not work.
Works
MySql = MySql & " AND PROGRESS.Update = #" & Format([Forms]![TabbedForm]![DULIST], "yyyy-mm-dd") & "#"
Does not work
MySql = MySql & " AND PROGRESS.Update = #" & Format([Forms]![TabbedForm]![LBL5].[Caption], "yyyy-mm-dd") & "#
Works
MySql = MySql & " AND PROGRESS.Update = #" & Format([Forms]![TabbedForm]![DULIST], "yyyy-mm-dd") & "#"
Does not work
MySql = MySql & " AND PROGRESS.Update = #" & Format([Forms]![TabbedForm]![LBL5].[Caption], "yyyy-mm-dd") & "#