I just upsized my Access mdb to a SQL server backend. Now I'm working on the access ADP project to make it work right, so here is the problem.

I have a tabel of Customers open with their orders listed in a subform. I use a command button to open an order in a detailed view. the command is below
*************** ***
Private Sub OrdersNew_Click ()
On Error GoTo Err_OrdersNew_C lick

Dim stDocName As...