>Nadya,
>
>Your seggestion works fine. But now I am needing to add a date field to my cursor. I add the field appdt D to the create cursor in the Load event. I know that my cursor is genertating the date by browseing before the append command but after the append command the created cursor has all blank dates. Any ideas?
No good ideas, except that probably your select has DateTime format and your cursor has Date format. It still should not be a problem. Check out, that AddDT field is called exactly the same in your cursor on Load and in your Select SQL cursor.
If it's not broken, fix it until it is.
My Blog