hi, I have found a way to search it, thought of it last night and have just tried it and it worked. Basically, although access displays the date in dd/mm/yyy format, it must still store it as yyyy-mm-dd.
I formatted the value of the datepicker to be yyyy-mm-dd before searching for it, and it has worked fine.
Thanks for your response though, it is really interesting to see how else this can be achieved.
Visit my site: http://www.drybonesuk.com