Using an opening dialog I open a form filtering to a specific record or to add a new record. The code works fine in a test environment on a single machine but when moved to a shared server location, the code is ignored and the form is opened to the first record. Also, using the Access Switchboard for navigation, using the 'Open Form Add' command (2) is ignored and the form opens in 'Open Form Browse' (3) mode at record 1. What am I missing?
The code in the opening dialog form is:
Private Sub cmdNew_Click()
On Error Resume Next
DoCmd.OpenForm "frm_MainVendors", , , , acFormAdd
Private Sub View_Click()
If IsNull([cmboVendorName]) Then
MsgBox "You must select a vendor."
Me.Visible = False
DoCmd.OpenForm "frm_MainVendors", , , "[SupplierID]=" & "Forms![fdlg_SelectVendor]![cmboVendorName]"