Access 2007-display value from table on a form

[hammer02]

I am trying to display the value from a "application defaults" table on an entry form to show the user the unit of measure they are working with.
The default unit of measure is stored in a single-record table (tblSystem).
I have a query that will return the value I want to display.
I'm having troubles figuring out how to get that field to be displayed on the form.
I've tried using the default value for a text field but that hasn't worked.
Any help in pointing me in the right direction would be greatly appreaciated.
Thanks,
Mike

 

[dhookom]

There are several options. The easiest is probably a text box with a control source like:

=DLookup("YourFieldName","YourTableName")

This works if your table/query contains only one record. If there is more than one record, you may need to add a where condition.

Duane
Hook'D on Access
MS Access MVP