Problem with changing query

[JackKaptijn]

I have got a query running on several tables.
The result is:

Customer Invoicedate Invoicenumber
100 13-2-2015 10001
200 NULL 20001
200 NULL 20002

I use a RecordSet to modify the field Invoicedate.
The recordset has a WHERE clausule Invoicedate <> NULL
Then it updates the Invoicedate.

The first record is OK.
With the second record it modifies the Invoicedate to Now()

The third record is going wrong.
Originally the Invoicedate was NULL but it has been modified by the second record.

Should I use another type of recordset?

Please help!

 

[CJ_London]

your post is very difficult to understand

there are two types of recordset, DAO and ADODB, it is most likely you are using the former and the issue is with your query.

So if you want help, provide details of the table you want to update and the query you are trying to use