Close Open Form on Open New

[scouser]

Hi to all. I have the code below that opens frmSalesOrders when clicked from frmCustomers. I have other buttons that utilize code DoCmd.Close acForm, Me.Name and they function as required. In this instance frmCustomers remains open behind the form called frmSalesOrders.

Private Sub OrderID_Click()
DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "frmSalesOrders", , , "OrderID = " & OrderID.Value
End Sub

Am I missing something obvious?
Thanks,
Phil.

 

[scouser]

I have put the following in the On_Load of frmSalesOrders. It works as required.

DoCmd.Close acForm, "frmCustomers"

Phil.

 

[pbaldy]

I would have thought your code would work. Is the second form modal maybe?

 

[MarkK]

I would have expected your code to fail since you reference the value of a member of that form after you've closed it.

 

[scouser]

Hi. The form is not set to Modal. It is now working as previously stated. Thaks for taking time to review.
Phil