I have reviewed many threads but none seem to share my specific problem.
I have one form (split) used to show all records in a dataview. I have added a column from which a spefic record's details can be reviewed in a seperate details form. Alternatively the user may select the 'new' button opening the details form from which a new record can be added. I wish to highlight, the details form is not a subform, it is a seperate form.
My issue is updating (i.e. requery) the original record browser form to reflect either changes to a record or the creation of a new record done using the details form.
The original browser form is called "frmQualificationsBrowser"
The details form is called "frmQualificationsDetails"
I have tried the following VB code in frmQualificationsDetails without success
Code:
Private Sub Form_Close()
Forms!frmQualificationBrowser.Requery
End Sub
I have also tried the following VB code in frmQualificationsBrowser, also without success
Code:
Private Sub Form_GotFocus()
Me.Requery
End Sub
Any help will be most appreciated.
Thanks
Peter