Problem opening a recordset with a variable name

[Felix18807]

RS.Open Me.txtTableName.Value, CurrentProject.Connection, adOpenKeyset, adLockOptimistic

Where txtTableName is a textbox on a form returns this error -2147217900

Does anyone know a fix for this?

 

[Felix18807]

Nevermind square brackets missing..

 

[SkipVought]

hi,

how about...

RS.Open Me.txtTableName.Value, CurrentProject.Connection, adOpenKeyset, adLockOptimistic[b], adCmdTable[/b]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[tedsmith]

RS.Open Me.txtTableName.Text, CurrentProject.Connection, adOpenKeyset, adLockOptimistic

or

MyTableName = Me.txtTableName.Text
RS.Open MyTablename, CurrentProject.Connection, adOpenKeyset, adLockOptimistic

 

[dilettante]

Drop the Me, it just adds clutter.