Hi
I'm now doubting myself here on a single form data clone, I want to clone the underlying data on a single form called frmProducts so that people can edit that data anytime they want to.
Here is what I'm doing:
it appears to be working without referencing frmProducts , that is where it is confusing me, maybe someone will be able to spot the mistake here.
I'm now doubting myself here on a single form data clone, I want to clone the underlying data on a single form called frmProducts so that people can edit that data anytime they want to.
Here is what I'm doing:
Code:
Private Sub CboSelectProducttoedit_AfterUpdate()
Me.Filter = "ProductID = " & Me!CboSelectProducttoedit.Value & ""
Me.FilterOn = True
Dim Records As DAO.Recordset
Set Records = Me.Form.Form.RecordsetClone
If Records.RecordCount > 0 Then
Records.MoveFirst
While Not Records.EOF
Records.Edit
Records.Update
Records.MoveNext
Wend
End If
Records.Close
End Sub
it appears to be working without referencing frmProducts , that is where it is confusing me, maybe someone will be able to spot the mistake here.