Dynamically opening a table

[H. Martins]

Using VBA, I need to open and read some records of another unrelated
table (not related to the present table structure).

Can I have some help please?

Thanks
H. Martins

 

[Allen Browne]

DLookup() might be the simplest way to find a value in a field of another
table:
http://allenbrowne.com/casu-07.html

If you need more than that, use OpenRecordset. Here's an example:
http://allenbrowne.com/func-DAO.html#DAORecordsetExample

 

[Guest]

PARAMETERS RID Long;
SELECT tblSub.enClass AS SysClass, tblSub.txtSubName, tblSub.hyperWorkSheet
FROM tblSub
WHERE tblSub.pkID)=[RID];

Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim rst As DAO.Recordset

Set db = CurrentDb
Set qdf = db1.QueryDefs("qryViewRID")
qdf.Parameters("RID") = lngID
Set rst = qdf.OpenRecordset(dbOpenSnapshot, dbReadOnly)