>Tamar,
>
>I tried a query on all the records using a Select/Browse and the new records did not show. I'll try using the SQLExec later today since I will be out. Will advise what happens. Appreciate your help.
>
>Thanks,
>
>Bill

Are you 110% sure that you work with the same table all the time????

I often test by switching between using SQLExec() and working directly on the same table using SQL management Studio. I add/change a record using SQLExec(), and immediately check if the change is visible in SMMS, and then I do it the other way. I have had some "head banging" moments".