Solved Datasheet is selecting more then one record (1 Viewer)

[silentwolf]

Hi again,

When I select a record in the datasheet view the form selects sometimes more then one record.

Does anyone know what cause this issue?

Cheers

 

[jdraw]

Please show the SQL of your Select query. It sounds like you are not selecting on some unique attribute.

 

[The_Doc_Man]

jdraw beat me to it. An SQL SELECT statement won't return a single record unless (a) that's all you've got or (b) your WHERE clause specifies some attribute uniquely. Otherwise, SELECT returns a set of records - which is why you deal in recordsets with Access.

 

[Gasman]

I read that to be selecting one record in a datasheet, yet for some reason two are selected, but I did not even know that could be done.

 

[silentwolf]

Hi,

thanks for your input.
I believe it had something to do with the mouse rather then something with my code.
Now it seams to work again.

So I keep you posted if there is it again.

Cheers

 

[isladogs]

Please provide a screenshot showing this if it recurs