Why does my form create duplicate records?

[Tony Williams]

I have a form that is based on a query. When I edit a record a new duplicate
record is created. Why is this happening? The query is set to Dynaset
(Inconsistent Updates)
TIA
Tony

 

[AranKappler]

Hi Tony,

I'm not an expert so my answer may not be as complete or succinct as it might
otherwise be.

This happens to me when I have a table in a query where there is more than
one record linked to the main table. e.g. if there are two addresses for one
customer and I use the address table in a query with the invoice table I
might get two invocie records instead of one. The way I get around it is by
making one of the addresses a "Main" address and filtering for that in the
query.

Like I said though, I am not an expert and there may be simpler ways of doing
it.

Cheers,

Aran K

 

[Tony Williams]

Thanks Aran I'll have a look at that possibility.
Cheers
Tony