Pranav sorry for the delay,

This is the code Iam using:

Set dgContractUnits.DataSource = AdodcUnits
AdodcUnits.CommandType = adCmdText
AdodcUnits.ConnectionString = myConn1
AdodcUnits.RecordSource = mySql1
AdodcUnits.Refresh

HTH
ADSC

>Thanks Ahmad but could you just give me the syntax for resetting the data source.... and also could you tell me how to use the requery operation for a data control.
>
>Thanks in advance
>Pranav Gore.