Grab Value from Combo Box

[Fattire]

I'm just trying to grab a value choosen by a combo box so I can use it else where in the form....the code below is all I've come up with and it doesn't grab the value clicked on in the combo box - it pulls nothing.

Combo box get's it's values from a SQL statement

Private Sub cbo_Listing_AfterUpdate()

Dim varName As String

Me.cbo_Listing.Value = varName

End Sub

 

[Fattire]

ooohhhhh, had the code backward, nevermind - copied too fast and then wasn't looking...sorry.

 

[ck1999]

thats because you typed it backward

try varname = me.cbo_listing.value

ck1999