populate a text box from a query?

  • Thread starter Thread starter keithb
  • Start date Start date
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
 
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

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top