populate a text box from a query?

K

keithb

I need to lookup descriptive text using a reference in a table that is being
edited by a form. Is there some way to populate a text box based on the
results of a query? This would be like using a combo box, except that there
is only one possible choice, so no list is needed.

Thanks,

Keith
 
F

fredg

I need to lookup descriptive text using a reference in a table that is being
edited by a form. Is there some way to populate a text box based on the
results of a query? This would be like using a combo box, except that there
is only one possible choice, so no list is needed.

Thanks,

Keith
Click to expand...

You can use DLookUp.
Assuming only one record is returned in the query:

=DLookUp("[FieldName]","QueryName")
 
Top