Amandeep singh
New member
- Local time
- Today, 04:50
- Joined
- Apr 6, 2020
- Messages
- 1
Hi everyone, I have a single Compile time error:Method or data member not found in my code. Can You guys solve or suggest me how to remove that error.
Code Tags Added by UG
Please use Code Tags when posting VBA Code
https://www.access-programmers.co.u...e-use-code-tags-when-posting-vba-code.240420/
I attached my program have a look. Please suggest or solve this problem.
Code Tags Added by UG
Please use Code Tags when posting VBA Code
https://www.access-programmers.co.u...e-use-code-tags-when-posting-vba-code.240420/
Code:
Option Compare Database
Option Explicit
Private Sub cboGoToEmployee_AfterUpdate()
' find matching row in form's recordset's clone
' and synchronize bookmarks if found
With Me.RecordsetClone
.FindFirst "EmployeeID = " & Nz(Me.cboGoToEmployee, 0)
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With
End Sub
Private Sub Form_Close()
On Error Resume Next
Forms("frmOpen").Visible = True
End Sub
Private Sub Form_Current()
' synchronize go to employee combo box
' with current record
Me.cboGoToEmployee = Me.EmployeeID
End Sub
I attached my program have a look. Please suggest or solve this problem.
Attachments
Last edited by a moderator: