Has anyone run into a situation where only certain processes are not behaving correctly on all versions of the front end?
I have an access DB Backend on Sharepoint. For the most part it works fine, but on one of the laptops containing a copy of the backend, some of the search modules aren't working that are attached to a combo box drop down to select a record.
Here's that code for one of the search combo boxes however, the same problem occurs on others on that form.
Code:
Private Sub Combo33_AfterUpdate()
Dim RS As Object
Set RS = Me.Recordset.Clone
RS.FindFirst "[CustomerID] = " & Me![Combo33]
If Not RS.EOF Then Me.Bookmark = RS.Bookmark
Me.Combo33.Requery
End Sub
In addition, code that minimizes a switchboard does not seem to be working on any forms (on this laptop but works fine elsewhere.
Here's that code:
Code:
Private Sub Form_Open(Cancel As Integer)
Forms![frmMainSwitchboard].Visible = False
End Sub
I doubt if the code has anything to do with it as the the database functions properly on other computers. I even took a copy of the backend from one of the other computers and put it on the laptop just to see if anything had inadvertently been changed and still, it did not function properly.
Has anyone seen any behavior like this or does someone have an idea as to where to go to fix it?
Thanks in advance
We are running access 2013 and I believe it's sharepoint 2013 version