case command

[alarants]

I have had some problems with case sentence:

Select Case T![Grupp]
Case "Other"
GoTo B
Case Null
GoTo B
Case Else
GoTo A
End Select

I had an idea that Case Null will fish out all empty fields but it does not. Neither does IsNull, IsEmpty, Empty, "". I appreciate if anybody could share experience in such a case.

Alarants

 

[alarants]

It helps if to do

Select Case Nz(T![Grupp], 0)

 

[JPaulo]

See;
http://www.blueclaw-db.com/select_case.htm