'Set Week Variables
If Week_From_Combo = "Please Select Week" Or Week_To_Combo = "Please Select Week" Then
TimeBox = MsgBox("Please Select a Time Range", vbOKOnly, "Unknown Time Period")
From_week = [Forms]![Form:_PCRKMS_Selection]![Week_From_Combo]
to_week = " and " & [Forms]![Form:_PCRKMS_Selection]![Week_To_Combo]
Now I would expect that if there is no time frame selected then the msg box will appear and the sub routine would then end.
The msg box appears but then the routine continues. Now this is not a big deal except for the fact taht It needs to stop!!
this code is the begging of a bit of code to populate a combo box. is that why the routine will not stop???
Any Ideas would be nice
I think that my problem was that i was trying to do this in the on focus of a combo, so the combo still tried to populate itself. I fixed it by putting combo.rowsource = "" after the if statment before the end statment.
Thanx for the help