Hi All
blimey i have been looking at this nearly all day, as soon as i posted i realised how i could do it
i have used this code and it appears to do what i want
Code:
Private Sub BackButton_Click()
Dim ThisMonth As Integer
If Me.MonthNumberTXTBox = 1 Then
Me.BackButton.Enabled = False
Exit Sub
Else
ThisMonth = Me.MonthNumberTXTBox - 1 'Month(Date) - 1
Me.MonthNumberTXTBox = ThisMonth
Me.Requery
End If
End Sub
i can put this on the forward button and change this ThisMonth = Me.MonthNumberTXTBox - 1 to ThisMonth = Me.MonthNumberTXTBox + 1
and disable the forward button when the month gets to 12
i think i have cracked it
Steve