>You might try checking the Recordset.Status property. This gives you the stats of the current record in the Recordset. If it is equal to adRecModified (2) then ...
>
>I haven't tested this so YMMV.
>

I have looked into Recordset.Status property and found that it is not what you are thinking of. It indicates the status of the current record with respect to batch updates or other bulk operations.

Thanks.


>>>>>>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.
>>>
>>>When I give that kind of functionnality, I use the Change event of every control to flag a variable and use this variable!
>>>
>>>I think that bound controls have the DataChanged property but I never use them!
>>
>>
>>
>>Is this the ONLY way to go? or are there any other ways? Anyone? Please help.
>>
>>Thanks