>1) As you told earlier we can not give two Select Statement for a one recordset.
> But I want to use the NextRecordset Method with the following code. may be
>my code will be wrong or may be I have not understood the concept of NextRecordset
>pls. help me e.g.

The help file says: «The NextRecordset method is not available on a client-side Recordset object.». Access alwasy use client-sided recordset and cannot be set to server-sided. So this method won't work for Access.


>2) Is there any command like @R,C as we have in FoxPro for printing a Character
> on a particular Position.

No.


>3) pls. tell me what is the difference between Space(Number) and Spc(n) as both
> gives the same output i.e. priniting so many spaces depending on the Nummber Or n

Not much differences. Spc was built to be Used with the Print # statement or the Print method to position output.


>4) Also when we create a Recordset based on more than One Table VB makes that
>Recordset as ReadOnly but for some reason I want to work on such type of
>Recordset how should I proceed.
> e.g.
> Dim Rs As New ADODB.Recordset
> Dim Str As String
>
> Str = "Select a.Id_No, a.Name, b.Salary From Table1 a, Table b" _
> &" Where a.Id_No = b.Id_No"
>
> With Rs
> .CursorLocation = adUseClient
> .LockType = adLockPessimistic
> .Source=Str
> .Open
> End With

The problem comes from the fact that you have the same column name in the tables you relate. If you had different column names, you could have use the recordset method (addnew, update, delete) to manipulate it. But since this is not the case, you should use the Execute method of the Connection object to send an action SQL query (Insert, Update, Delete).