I have created an unbound form that is erroring out when I try to save the current record. Do I need to define the type of data?
Sub SaveCurrentRecord()
'save the values in the controls on the form to the current record in the local disconnected recordset
If Not rsCustomer.BOF And Not rsCustomer.EOF Then
rsCustomer!Customer = Me.Customer
rsCustomer!TktCnt = Me.TktCnt
rsCustomer!Refund = Me.Refund
rsCustomer!NetSales = Me.NetSales
rsCustomer!AirComm = Me.AirComm
rsCustomer!CarComm = Me.CarComm
rsCustomer!HtlComm = Me.HtlComm
rsCustomer!RailSales = Me.RailSales
rsCustomer!RailComm = Me.RailComm
rsCustomer!SFCnt = Me.SFCnt
rsCustomer!SF = Me.SF
rsCustomer!SFComm = Me.SFComm
rsCustomer!Period = Me.Period
End If
End Sub
I am very much a rookie, would you explain the difference in Bound and Unbound and why unbound is used. Where is the unbound data stored until it is saved to the recordset?
Sub SaveCurrentRecord()
'save the values in the controls on the form to the current record in the local disconnected recordset
If Not rsCustomer.BOF And Not rsCustomer.EOF Then
rsCustomer!Customer = Me.Customer
rsCustomer!TktCnt = Me.TktCnt
rsCustomer!Refund = Me.Refund
rsCustomer!NetSales = Me.NetSales
rsCustomer!AirComm = Me.AirComm
rsCustomer!CarComm = Me.CarComm
rsCustomer!HtlComm = Me.HtlComm
rsCustomer!RailSales = Me.RailSales
rsCustomer!RailComm = Me.RailComm
rsCustomer!SFCnt = Me.SFCnt
rsCustomer!SF = Me.SF
rsCustomer!SFComm = Me.SFComm
rsCustomer!Period = Me.Period
End If
End Sub
I am very much a rookie, would you explain the difference in Bound and Unbound and why unbound is used. Where is the unbound data stored until it is saved to the recordset?