H
Harry F.
Hello all,
I have two unbound textboxes populating a table base on the code below. I
recently split this database, and the population no longer occurs. Do I need
to set the DB to the back-end database? What else might be going on here?
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim D As DAO.Database, R As DAO.Recordset
Set D = CurrentDb()
Set R = D.OpenRecordset("tblAllRequests")
If IsNull(R![FunnelManagerID]) Then
R.Edit
R![FunnelManagerID] = Me!txtUserID
R.Update
End If
If IsNull(R![FunnelManagerName]) Then
R.Edit
R![FunnelManagerName] = Me!txtUserName
R.Update
End If
End Sub
Thanks,
Harry
I have two unbound textboxes populating a table base on the code below. I
recently split this database, and the population no longer occurs. Do I need
to set the DB to the back-end database? What else might be going on here?
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim D As DAO.Database, R As DAO.Recordset
Set D = CurrentDb()
Set R = D.OpenRecordset("tblAllRequests")
If IsNull(R![FunnelManagerID]) Then
R.Edit
R![FunnelManagerID] = Me!txtUserID
R.Update
End If
If IsNull(R![FunnelManagerName]) Then
R.Edit
R![FunnelManagerName] = Me!txtUserName
R.Update
End If
End Sub
Thanks,
Harry