Setvalue from a Table Row

[Zardoz_TX]

I have a few tables that have 5-10 text entries.

I would like to create a Macro so that I can set a Form Value equal to one
of the rows in the table. I know I can do this directly in the Macro(with out
using the table), but I want to make it easy for the user to edit the text
and tables are easier to edit than are macros.

So It would be something like -
[Forms]![TPR]![TPR1] to be set to the Nth row of
[Plan]![Text]

Using SetValue - or what ever would work.

TIA!!!

 

[Steve Schapel]

Zardoz,

"the Nth row of [Plan]![Text]" means nothing to Access. If it was a query,
that had a sort order explicitly applied, the "Nth row" means something.
But not a table. You have to identify a row according to *data*, typically
the value of the primary key, not according to ordinal position.

 

[KARL DEWEY]

Tables do not have rows but have records. They are stored like a barrel of
bricks, jumbled.
If you want a particular record you must either use criteria or sort and
then go to that record.