Access wil not allow me to navigate between records

[cmcquain]

Help please. I have put some VBA code into my database to link and text boxes to different tables. The code works, but once I enter a Tracking Number that finds a NABP number I am unable to go to a dofferent record or save. I also want to edit the fields so I am unable to use a query since you cannnot edit queries. Here is the sample of my code.

Private Sub Form_AfterUpdate()
On Error Resume Next
    Dim db As Database
    Dim rs As Recordset
    Dim ctl As Control
    If Me.[Nature Investigation] = 1 Then
        Set db = CurrentDb
        Set rs = db.OpenRecordset("SELECT * " & _
                                    "FROM Feedback " & _
                                    "WHERE [NABP] = '" & Me.[Tracking Number] & "' ")
        
        Me.[Request Title] = rs![PharmName]
       ' Me.[OptCaseSent] = 1
        Me.[Date Received/Sent] = rs![Sent to CFI]
        Me.[Requester Name] = 3
        Me.[Request Type] = 2
        
        rs.Close
        Set rs = Nothing
        Set db = Nothing
        
    End If
    
End Sub

Help would be wonderful. This is driving me nuts.

[Dal Jeanis]

"You cannot edit queries"?

First, let me welcome you to the forum. Access is big and wide and deep, and a great tool once you learn the basics. It's an even better tool when you learn some of the cool bells and whistles.

This one's basic.

You CAN edit most queries, and they are the standard way of updating data. You link the form and its controls to an appropriate query, and all the details of updating are handled automatically.

So, create the query that has the information you need, put that query as the form's record source, and link each field on the form to the underlying field on the query. That handles most of it. (If you create the query, then select the query in the nv pane and then on the create tab click the the form creation wizard and the wizard will set up a lot of that automatically.)

If you want to limit the query by a filter to certain records, or if you want to use an unbound field to help position the query to a particular record, then you can put an unbound selector control or text box on the header of the form, and use the AfterUpdate event of the control to set the filter value, or to establish the position on the query by using VBA to set a bookmark.

Here's Allen Browne's exception list of what kinds of queries CANNOT be updated. http://allenbrowne.com/ser-61.html