My Forms record source is a query and I'm trying to populate a field from an array called Tracks. Code is
Seems to be editing the recordset but changes are not reflected in either Form_frmHubAddress or it's underlying table.
Where am I going wrong?
Code:
Set dc = CurrentDb.OpenRecordset(Form_frmHubAddress.RecordSource)
If dc.RecordCount > 0 Then dc.MoveLast
If dc.RecordCount = UBound(Tracks) Then
dc.MoveFirst
For c = 1 To UBound(Tracks)
dc.Edit
dc(3) = Tracks(c)
dc.MoveNext
Next
End If
Seems to be editing the recordset but changes are not reflected in either Form_frmHubAddress or it's underlying table.
Where am I going wrong?