Carsten,
So do I.
But it bugs me that it takes oApp.gc_user but it won't take thisform.lc_orderStatus.
It might be that oApp.gc_user was created before the form was instantiated.
>>
Bill -
I always do the following:
lcOrderStatus = thisform.lc_orderStatus
lcUser = oApp.gc_user
"EXEC sp_Update_Atmservice ?ln_transid, ?lcOrderStatus, ?lc_notes, ?lcUser"
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.