to show a recordset as table

[michele de meo]

use this vba code after to connect Access to a remote db. I obtain a
recorset and I want to show it as "table". I bind this recordset to a
form, but how to show as table?
This is the code (associated to a clik of a command botton):

Set recSet = New ADODB.Recordset
With recSet
Set .ActiveConnection = con 'con is the connection
defined above in the code
.Source = "select var1 from datamart where rix=4"
.LockType = adLockBatchOptimistic
.CursorType = adOpenKeyset
.CursorLocation = adUseClient
.Open
End With
Set Me.Recordset = recSet
After this code I correctly bind the recordset to the form , and if I
set the Form to "spreadsheet", I obtain a table with the just number of

records but without fields......
Someone could hel me?
thanks
michele de meo

[pietlinden]

any reason a link to the table won't work?

or you could, I think, use IN to specify the table(s) you are querying.

SELECT...
FROM SomeTable IN C:\PathToDB.mdb
WHERE