I have created a Continuous form and locked all the fields from editing. Each row has a button, the button opens another form in a dialog window so the data can be edited.
The issue I'm having is when the user updates the data in the dialog form, the continuous form does not update.
I have tried refresh, but it doesn't do anything. I tried requery, but this causes the continueous form view to jump to the top.
So I tried selecting the record afterwards, but this still makes the view change.
Below is what I currently have, is there a better way so when the dialog window closes, the continuous form updates with any changes AND the user's view stays where it is.
The issue I'm having is when the user updates the data in the dialog form, the continuous form does not update.
I have tried refresh, but it doesn't do anything. I tried requery, but this causes the continueous form view to jump to the top.
So I tried selecting the record afterwards, but this still makes the view change.
Below is what I currently have, is there a better way so when the dialog window closes, the continuous form updates with any changes AND the user's view stays where it is.
Code:
Private Sub cmdEditRecord_Click()
Dim current As Integer
current = Me.CurrentRecord
DoCmd.OpenForm "frmAssessment", , , "AssessmentId = " & Me.ID, , acDialog
Me.Requery
DoCmd.GoToRecord , , acGoTo, current
End Sub