>>Hi,
>>
>>I'm new to VB. I'm using VB and SQL for my app. I can't find a way to detect changes made to a recordset. Would somebody help me on this? Please provide some simple codes. This will be really helpful.
>
>Which changes? Changes made by other users once a recordset is open? You need a server sided cursor (CursorLocation = adUseServer) with a CursorType set to adOpenKeySet or adOpenDynamic.

Sorry that i was't clear on my question. This is my situation. I have created a VB form with a few controls on it. These controls are hooked up to an ADO recordset. In addition, I have a 'save' and 'close' buttons on my form. If an user makes some or no changes to my form, when he/she click on the 'close' button, I want to detect if there are any changes made so that i can prompt him/her.

Thx.