Open recordset

[Praveenevg]

Hello ,

I am currently using this statement to get access to records in my MS-Access table:
Set rs = CurrentDb.OpenRecordset("SELECT * FROM MASTER_JOB_LIST")

Is there anyway to pass name of the "Table" to be opened in a dynamic manner? In this case, I hard coded the table name as MASTER_JOB_LIST; Is there anyway to pass name of this table through a variable?

[amrut]

Yes,

Dim strSQL as String
strSQL="SELECT * FROM " & [YourVariableForTableName]
Set rs = CurrentDb.OpenRecordset(strSQL)

[Praveenevg]

Thanks. It worked.