>Hi,
>
>Thanks
>btw, how to manipulate it in data control coz im using a data control in my app.
>
>i used to manipulate the like this
>set frmother.mydata.recordset = frmsample.data1.recordset
>

In ADO, this would work but not with DAO.

Use this method instead:
With Data1
.DatabaseName = mdbMAJ.Name
.Connect = mdbMAJ.Connect
.RecordSource = "Your query string here"
.Refresh
End With