I have a Weeks table, which has several fields including WeekID and WeekCurrent. WeekCurrent= True indicates that row is the current week.

So I have a setup like this
Form = fDiary
Navigator = WeekBindingNavigator
bound to WeeksBindingSource -> datasource of PlannerDataSet

When the form opens, it displays the first week. But I want to display the week that is current. Then if the user clicks on the previous record button on the navigator, it should go to the previous week.

Whats the best way of doing this?
Thanks


Awesomo