Thread: MS Access - Case Statement Syntax

I need your help once again.

I have a query with two fields (Language and Team)
I need a public function that will help me populate the Team field based on the Language field.
For example if Language = "WO", then the function should return "Team1" for the Team field. If Language = "FR", then "Team2"... etc

This is what I have so far:

Public Function get_team(Lang) As String

     Select Case Lang
        Case "WO"
            get_team = "Team1"
            
        Case Else
            get_team = "LastTeam"
                        
    End Select
End Function

Obviously, this code does not work. But, I have no clue where to add what is missing... maybe a declaration or a formula to indicate the Team and Language fields in the argument.

Thx in advance for any help provided

Try

Select Case Lang.value

Alan

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

??? I read rule #5... how did I violated the rule???? I didn't post this question is another forum and I did post it in the correct forum "Access Programming". Isn't a public function VBA code???

I have been holding out on posting on this because there was a post by RoyUK. I couldn't figure out why either tbh.

I pm'd roy. Waiting for a response.