recordset update is creating new records instead of updating them.

[saudkazia]

hi all

im trying to do a simple update of all the records in continuous subform.

i have the following code set to the submit button on the main form

 

Dim rsw As New RecordSetWrapper

 With rsw.GetRecordsetClone(Me.frmbill_worksubform.Form.Recordset)                While Not .EOF
        If IsNull(![outdate]) Then
                     
               rsw.Edit
               ![outdate] = Now()
               rsw.Update
                        
                    End If
                    rsw.MoveNext
                Wend
            End With

what this is doing is creating a new entry in my workcard table which i definitely don't want.

relevant tables
bill | bill_work | workcard

relevant forms
frmbill | frmbill_worksubform


the bill table is the main table that lists all the bills with billid | customerid | bdate | total amount
the bill_work table lists the details of the bill based on the detailid | billid | work_id | unit_amount
the workcard table lists all the details of each item with workid | indate | all sorts of different fields pertaining to that item | outdate



basically the workcard is the work order of the item. when an item is ready to sell it will be selected in the frmbill_worksubform. when i hit the submit button the outdate should populate for each item in the subform hence showing that it is sold. those items that don't have an outdate will be available to select in the subform but those that have an outdate will not be shown for selection as naturally they are not available anymore.

can someone point to how i can do this. i am using northwind traders 2007 as my base template.

[ranman256]

why are you using code?
use an update query to ENSURE an update query.

[saudkazia]

why are you using code?
use an update query to ENSURE an update query.

i am thinking the code is easier to manage then update query. how would i go about doing the update query. meaning how to let it know that i only want the records that meet the criteria based on the frmbill/frmbill_worksubform billid