I have a form that is intended to allow a user to update only certain aspects of the record set, and it has been quite a while since I have done this....

I do have a working one of these to go by - but am needing to make a new database - and fields have been modified, and for some reason - no matter how many times i cut and paste the original code - and modify the field names... it just won't work.

basically what I am trying to do is allow the user to enter an inventory # in the 1st box on the form - when they hit enter the rest of the record's data should appear - if there is any -

I have

a combo box for this particular field - which is called Inventory

in the properties of said box
Data Row Source Type is Table/Query
Data Row Source SELECT [tblInventory].[Inventory]FROM [tblInventory]; (when i save the form the brackets go away..?)
Bound column 1
Limit to List Yes
Auto Expand Yes
Enabled Yes
Locked No

the events are:
Before Update [Event Procedure] but nothing coded
After Update [Event Procedure] coded as follows:
Code:
Private Sub Inventory__AfterUpdate()
    ' Find the record that matches the control.
    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[Inventory] = " & Str(Nz(Me![Inventory], 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub


what am i missing?
please help i know office 2003 is not the "preferred" version - but this is for a customer and that is what they have.