Thanks Andre and hermanvd
To hermanvd,
I haven't tried your method, but I will sometime today when I get the time.
Thanks
Andre,
Yes, I realised after I posted that the slashes were the wrong way around. I changed them in my code and it worked fine. Sometimes you just don't see it......Maybe I need my eyes testing or something !!!
Here is what I'm using to fill a combo with the present and last 2 months (Just in case anyone else has the same prob)
Code:
With Me.CmbMonths
For i = 0 To 2
LasMon = (Month(Date) - i) & "/" & Day(Date) & "/" & Year(Date)
MyMonth = Format(LasMon, "mmm")
.AddItem MyMonth
Next
.ListIndex = 0
End With
Thanks anyway
Cheers
Steve