Reference a particular field/row

[diverman]

From a table, how do I get the data from a particular row and field into a text box.?

I have tried a searching the forum, but I can't find ROW and field to text box.
TIA, Gordon.

[Tanis]

You can't. You can use a combo box or a list box though.

[NeoPa]

Use =DLookUp() in the 'Control Source' property of your TextBox.

Syntax

DLookup(expr, domain[, criteria])

The DLookup function has the following arguments.

Argument Description
expr An expression that identifies the field whose value you want to return. It can be a string expression identifying a field in a table or query, or it can be an expression that performs a calculation on data in that field. In expr, you can include the name of a field in a table, a control on a form, a constant, or a function. If expr includes a function, it can be either built-in or user-defined, but not another domain aggregate or SQL aggregate function.
domain A string expression identifying the set of records that constitutes the domain. It can be a table name or a query name.
criteria An optional string expression used to restrict the range of data on which the DLookup function is performed. For example, criteria is often equivalent to the WHERE clause in an SQL expression, without the word WHERE. If criteria is omitted, the DLookup function evaluates expr against the entire domain. Any field that is included in criteria must also be a field in domain; otherwise, the DLookup function returns a Null.

[Tanis]

Oops, forgot about DLookUp. Nice one.