I created 4 forms that are all based on RequestT.  Each form only showing the fields pertaining to that form.

I have an EmployeeF that contains buttons that will open the form that needs to be completed.  I also have a listbox (ServiceRequestListBox) that is on EmployeeF showing all of the different forms that I completed for THAT employee.  

The Listbox is Based on:  
SELECT [ServiceRequestID], [DateITNotified], [ServiceRequestType], [StatusName], [DateDone] FROM ServiceRequestForCurrentEmployeeQ ORDER BY [DateDone] DESC;

I need it setup so that when i double click on record in the listbox, it will open the record for that employee so i can see the details.  

This worked fine when i only had 1 form (RequestF) to enter information into.  

Private Sub ServiceRequestListBox_DblClick(Cancel As Integer)
On Error Resume Next
DoCmd.OpenForm "RequestF", , , "RequestID=" & RequestListBox
End Sub

But now that there is more than 1 form (NewF, TerminateF, SuspendF etc), it opens all of the forms at once whether was a record for the employee to begin with or not.

Private Sub ServiceRequestListBox_DblClick(Cancel As Integer)
On Error Resume Next
DoCmd.OpenForm "SRNewF", , , "ServiceRequestID=" & ServiceRequestListBox
DoCmd.OpenForm "SRNameF", , , "ServiceRequestID=" & ServiceRequestListBox
DoCmd.OpenForm "SRReactivateF", , , "ServiceRequestID=" & ServiceRequestListBox
DoCmd.OpenForm "SRSuspendF", , , "ServiceRequestID=" & ServiceRequestListBox
DoCmd.OpenForm "SRTerminateF", , , "ServiceRequestID=" & ServiceRequestListBox
End Sub

Is there a way to fix this?

---

Reply from Alex Hedley:

You are telling it to open each Form.

You would need to check if there is a record first before you open it.
You could use the DOMAIN function to check if there is a record and if so open the Form.