Hello All,
I'm having trouble with a bit of code, I'm hoping someone knows what is going on.
The purpose is to close a form, then open again to a new record with the same information as the previous record. From there, the user will only have to make a small change to one field, rather than entering everything from the beginning.
Private Sub cmdDup_Click()
Dim strForm As String
strForm = "frmTireInvDetail"
DoCmd.Save acForm, strForm
DoCmd.GoToRecord , strForm, acNewRec
Me.Qty = Me.dupQty
Me.Mfr = Me.dupMfg
Me.Mdl = Me.dupMdl
Me.Size = Me.dupSize
Me.DOT = Me.dupDOT
Me.RecDt = Me.dupRecDt
Me.Cmnt = Me.dupCmnt
Me.Locn.SetFocus
End Sub
The Me.dup fields are all DLookup references of the previous record.
Everything works exactly the way I want it...on my computer. On the computers of the 3 other users, nothing happens at all. No error messages, the form just sits there like you never clicked anything at all.
All of the computers are running the latest version of Windows 10, Access 16, all accessing the same server to get to the database. I have checked the Reference Library on my computer, and as far as I can tell, everything looks normal. Doesn't the Reference Library follow the database, so I wouldn't have to check it on the other computers if it works correctly on mine? I don't think it would be anything with the code since it works on my computer.
Any help would be much appreciated.