>Thanks Borislav
>
>The problem I have is that it works fine until I set the controlsource to my table then it doesnt work.
Are you sure you have at least one record or not in EOF() or BOF() state in table?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.