Thanks for the response. I do currently have an unbound form set up but I am
having several errors. After I add 5-6 records to the form I "Save All Changes
to the Database" I receive this error: Multiple-step operation generated
errors. Check each status value. It bombs on the third line. I have it set-
up as an interger because it contains a value. Can you give me any ideas.
Another question is when I add several records to the form where is this stored
until I add it to the database?
Sub SaveCurrentRecord()
'save the values in the controls on the form to the current record
'in the local disconnected recordset
'1 If Not rsCustomer.BOF And Not rsCustomer.EOF Then
'2 rsCustomer!txtCustomer = Me.txtCustomer
'3 rsCustomer!intDCnt = Me.intDCnt
rsCustomer!intDRfds = Me.intDRfds
rsCustomer!intDRfdSales = Me.intDRfdSales
rsCustomer!intDNetSales = Me.intDNetSales
rsCustomer!intDAirComm = Me.intDAirComm
rsCustomer!intICnt = Me.intICnt
rsCustomer!intIRfds = Me.intIRfds
rsCustomer!intIRfdSales = Me.intIRfdSales
rsCustomer!intINetSales = Me.intINetSales
rsCustomer!intIAirComm = Me.intIAirComm
rsCustomer!intTNetSales = Me.intTNetSales
rsCustomer!intTourComm = Me.intTourComm
rsCustomer!intSNetSales = Me.intSNetSales
rsCustomer!intShipComm = Me.intShipComm
rsCustomer!intRNetSales = Me.intRNetSales
rsCustomer!intRailComm = Me.intRailComm
rsCustomer!intCNetSales = Me.intCNetSales
rsCustomer!intCarComm = Me.intCarComm
rsCustomer!intHNetSales = Me.intHNetSales
rsCustomer!intHtlComm = Me.intHtlComm
rsCustomer!intSFCnt = Me.intSFCnt
rsCustomer!intSFNetSales = Me.intSFNetSales
rsCustomer!intSFComm = Me.intSFComm
rsCustomer!intMiscNetSales = Me.intMiscNetSales
rsCustomer!intMiscComm = Me.intMiscComm
rsCustomer!txtPeriod = Me.txtPeriod
rsCustomer.Update
End If
End Sub
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
