When a drop down changes parsing first piece into another field

[jock95]

I have a field on a form that when I change the selection I want the first part of that field to be parsed and changed in another field.

Example. I have a list box with the following.

Books - Doc 7 6180

In the other field, I need this to happen in the on change() cmd.
Left([Cell_Loc],InStr([Cell_Loc],'-')-1)

Hope this makes sense.

 

[Remou]

Something like this: (?)

Private Sub List2_Click()
Me!Text0 = Left(Me!List2.Column(0), InStr(Me!List2.Column(0), "-")-1)
End Sub