Search using number type. 1

[vicktown2]

Hello, i am using a drop down list of numbers that will be used to populate a form when a number is selected. I have been able to do this successfully when basing my find on a text type using the code below. How can i alter this code to make it work for a number?
I know i should be removing the quotations but there seems to be bigger problems. Any ideas?


Sub Combo142_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[ShortName] = '" & Me![Combo142] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

 

[PaulF]

remove the delimiter around the Me![Combo142]

Me.RecordsetClone.FindFirst "[ShortName] = " & Me![Combo142]

PaulF