Displaying Queries

  • Thread starter Thread starter Steven Smith
  • Start date Start date
S

Steven Smith

Perhaps this is a better worded question.

How do I display the results from any given field in any
given query to a textbox on a form, presumably this has
to be through the textboxes control source.

My basic understanding leads me to believe it should be
something along the lines of:

=[QueryName.FieldName]

???

Thanks in advance

Regards Steve...
 
Steven,
I presume you mean the result of one record in the query, not the result of
1000 records.

=DLookUp("[FieldName]","QueryName","You will need criteria here if the query
returns more than one record")

Look up the DLookUp function in Access help.
 
Back
Top