this is the code by using wizard... can someone convert this to a more understandable code?
Private Sub customerid_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[customerid] = " & Str(Nz(Me![customerid], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Also, check in the Form/Properties and look for the OnCurrent Event. If the wizard didn't create it simply do this. In the OnCurrent event for the form input this code: Me!CustomerID = customerid