Hi,

The code I had written on the thread was not what I had in the program. there have been some typo :)

Some how the set delete have been on, that is why it wasn't showing me all the records. At first I thought I had the set delete off, any way it is working now.

Thanks again.