subform update field

[bigmac]

hi all, on a subform ihave two fields [position] and [approved], in [position] is a lookup, the lookup list is as follows
6G
5G
4G
3G
2G


1G
after i select one of the above i would like [approved] to load some text depending opon what was selected in[position], example [position] = 6g then [approved] would display "all".
i have tried the following and placed it in the onupdate property
if me.position = "6G" then approved = "ALL"
end if
but how do i ask it to look at[position] and if its "5G" then place something else in [approved], then if its "4G" put something else in "approved" etc, also is it better to put this code in after update , on dirty,lost focus, or what?

[June7]

I use only VBA. In AfterUpdate event property select [Event Procedure]. Double click the ellipses (...). This will put you in the procedure in the VBA editor. Type code, like:

Select Case Me.position
Case "4g"
Me.approved = "something"
Case "5g"
Me.approved = "something"
Case "6G"
Me.approved = "All"
End Select

Or like:

Me.approved = Switch(Me.position="4g","something", Me.position="5g","somethingelse", Me.position="6g","All")

Are there only the 6 values? Expand the code to include the other 3.

Or like:

Me.approved = Choose(Left(Me.position,1), "something1", "something2", "something3", "something4", "something5", "All")

If there are a lot more than 6 values, need to do lookup on table.