Hi,
I would like to DIM a Recordset using a string to provide the table name. Table for the recordset varies depending on users choice from a listbox
eg
strAccountID = Me.lbHeader.Column (1)
tbName = "tb" & strAccountID
Then I would like to use the tbName string to
Dim tbName As DAO.Database
Dim tbName As DAO.Recordset
But does not work
have tried
Dim " & tbName & " As DAO.Database etc but does not work either.
Any help very much appreciated
Colin