We help IT Professionals succeed at work.
Get Started

Open Form event won't filter on Network Shared Server drive

LamontZone
LamontZone asked
on
367 Views
Last Modified: 2012-05-11
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
   
End Sub

Private Sub View_Click()
    If IsNull([cmboVendorName]) Then
        MsgBox "You must select a vendor."
        DoCmd.GoToControl "cmboVendorName"
    Else
        Me.Visible = False
        DoCmd.OpenForm "frm_MainVendors", , , "[SupplierID]=" & "Forms![fdlg_SelectVendor]![cmboVendorName]"
    End If
End Sub
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 8 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE