How to pop data from a table in MS Access 2003?

why does the next statement result in an error message?

MsgBox Application.CurrentData.AllTables(tblECG).Properties.Item(1).Value

The Error: " The expression you entered refers to an object that is closed or doesn't exist'.

error number: 2467

any other suggestions to get a specified value from a table?

[342 byte] By [gilbil] at [2007-12-23]
# 1

Hi

What are you trying to read form the table, data or one of its properties?

ADG at 2007-8-31 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
# 2

Hi,

Could this be because you missed the quotes around the table name

MsgBox Application.CurrentData.AllTables("tblECG").Properties.Item(1).Value

DerekSmyth at 2007-8-31 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...