Thanks June7 for detail suggestions. That is my new Save event
Code:
Private Sub btnSaveClose_Click()
On Error GoTo Err_Save_Click
If Form.Dirty = True Then
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Form_fInventory.lstRequest.Requery
Form_fInventory.lstRequest = Me.RequestID
End If
DoCmd.Close
Exit_Save_Click:
Exit Sub
Err_Save_Click:
MsgBox Err.Description
Resume Exit_Save_Click
End Sub
What do you think?
I need help to display of all values of a record on my child fRequest form when I open it by double click record on ListBox of the parent fInventory form. Now when I double click record all controls related to Device and Location keep blank. I will appreciate if you will show how it to do on a sample.
Thanks