Take the last letter off contents of form combo box

[dixie]

I have a combo box on a form that contains some text of the type "Warning
Letter 3" (this is the bound field). I want to take the last character from
the contents of this combo box and place it in another text box that is
bound to another field - in this case, I would want the number 3 to go into
a different text box on the form, called WarningNumber.

Can someone help me with the context of the VBA code I need to do this?

dixie

[PC Datasheet]

Me!WarningNumber = Right(Me!NameOfCombobox,1)

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"dixie" <di****@dogmail.com> wrote in message
news:5t***************@nnrp1.ozemail.com.au...

I have a combo box on a form that contains some text of the type "Warning
Letter 3" (this is the bound field). I want to take the last character from
the contents of this combo box and place it in another text box that is
bound to another field - in this case, I would want the number 3 to go into
a different text box on the form, called WarningNumber.

Can someone help me with the context of the VBA code I need to do this?

dixie

[Wayne Gillespie]

On Sat, 24 Jul 2004 09:03:36 +1000, "dixie" <di****@dogmail.com> wrote:

I have a combo box on a form that contains some text of the type "Warning
Letter 3" (this is the bound field). I want to take the last character from
the contents of this combo box and place it in another text box that is
bound to another field - in this case, I would want the number 3 to go into
a different text box on the form, called WarningNumber.

Can someone help me with the context of the VBA code I need to do this?

dixie

On the AfterUpdate event of the combo -

If Not IsNull(Me.MyCombo) Then
Me.WarningNumber = Right(Me.MyCombo,1)
End If
Wayne Gillespie
Gosford NSW Australia