Update sub-form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Form (Form1), with a subform created as "Datasheet" which contains
several records. I doubleclick on a record and launches a form (Update
Record) to update/edits the selected record, and as soon as I update/edit the
record the new information shows on "Form1". When I add a new record using
the "Update Record" form, the new record does not show unless "Form1" is
closed. I have tried "Refresh", and "Requery" using the "On Close", "After
Update", and also "Befor Update" without results. How do I accomplish this
without manually closing the main form (Form1)?
 
This was the code created when I added a "Refresh" command button.

Private Sub Command5_Click()
On Error GoTo Err_Command5_Click


DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

Exit_Command5_Click:
Exit Sub

Err_Command5_Click:
MsgBox Err.Description
Resume Exit_Command5_Click

End Sub
 
I have tried this option along with refresh and it did not work. It did not
work this time either.
 
Back
Top