Access 2007 Combo Box

[TClark14]

ON my form I created a combo box (using the wizard) to Find a Record based on the Value I select and it will not work. When I choose from the records in the combo box nothing happens, no errors, just nothing. It's probably something simple that I am overlooking - I did this all the time in 2003, but nowing Access 2007 and I can't seem to get it to work. Any ideas? THANKS!

Here is the code provided by the wizard

Private Sub Combo97_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[WELL NAME] = '" & Me![Combo97] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

(WELL NAME is the field in my records that I am using to "find" when I make my selection in the combo box)

The Record Source of the Combo Box is
SELECT [tblDrillingDatabase].[WELL NAME] FROM [tblDrillingDatabase];

The Row Source Type is Table/Query

 

[boblarson]

Have you done this yet:
http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx

 

[TClark14]

Thank you! That's all it needed to work.