Expression

[Stout]

I have an unbound text box and I want to create an expression so that
it gets its default value from a table ADMIN that contains a field
named CURRENT.

How is this be done?

Thanks!

 

[Brendan Reynolds]

You can use the DLookup function. Here's a link to the on-line help topic
....

http://msdn.microsoft.com/library/d...n-us/vbaac11/html/acfctDLookup_HV05187182.asp

 

[fredg]

I have an unbound text box and I want to create an expression so that
it gets its default value from a table ADMIN that contains a field
named CURRENT.

How is this be done?

Thanks!

Set the control's Default Value property to:

=DLookUp("[Current]","Admin")

The above will return the value from the first record in the table. If
you have more than one record in the table you will have to add a
Where clause to the above expression to find the correct record.
See VBA help files on:
DLookUp and also Restrict data to a subset of records

However, since the control is unbound, what do you intend to do with
the result?