Help with Coding Value on Form

[Frank]

This has been bugging me all day. I have a standard form
that contains a text box at the top of the form. I have a
dynamic value in a table that I would like to appear on
the form. Basically, a cell reference so that whatever
value is in the table (just one field) will appear in the
text box on my form. I hope this makes sense and I know
it deals with Expressions and the Control Source. Thanks!

Frank

 

[fredg]

This has been bugging me all day. I have a standard form
that contains a text box at the top of the form. I have a
dynamic value in a table that I would like to appear on
the form. Basically, a cell reference so that whatever
value is in the table (just one field) will appear in the
text box on my form. I hope this makes sense and I know
it deals with Expressions and the Control Source. Thanks!

Frank

You have a table with just one value in a Field?
In the control source of an unbound control:

=DLookUp("[FieldName]","TableName")

Look up the DLookUp function in VBA help for additional arguments.

If you do need criteria to find the correct record,
in Access help look up
Restrict + Restrict data to a subset of records.