Hi Lafor

Thanks for your quick reply :-))

I found some MS Access information and now it works..

Here is the code that works

Adodc1.RecordSource = "SELECT * FROM Ugerapport WHERE Dato=#" & test & "#"
Adodc1.Refresh

I have tried with the quotes but it didn't work in my code!!

Anyway thanks again..

Regards
Allan