>
>For now I mapped to the array. Works anyway....but did notice you made an additional cursor too.
The cursor is the crux of the system, the array contains the structure of the cursor.
That's why I posed the question. Let's see if I understand what's going on; you create this temp cursor based on the array and map the controlsource to it? Do you use SQL code for INSERT/UPDATE/DELETE or how are you transferring the data from a temp cursor to the database once a user has hit "Save" or whatever mechanism you use?
I transfer only when the user has hit Save. But nothing prevents me to update the actual database on the fly of course, but the circumstances where that was necessary have yet occured to me. I guess in real time multiuser stock management that is something to be considered.
The saving occurs under a transaction construct. That is as robust at it gets.
Marc
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.