Halting script with Case Else

[Ekhart]

I have a multi-tiered case system set up. The first set is identifying the user. Is there a way that if a name not on the list is entered (this would fall under Case Else) to halt the script right there. I have a msgbox pop up but it also gives a code error when trying to run the remainder of the code.

[ranman256]

Wouldn't it just be an IF,Then?

vUser =Dlookup(...)
if IsNull(vUser) then
   MsgBox "not on file"
else
   MsgBox "valid user"
endif

[John_G]

Just put Exit Sub after the Msgbox line.

[Ekhart]

Dang so easy Thanks John_G!