Form question: Simplest way to bring in a query result that is notthe record source into a form?

X

xyzer

I have a query that produces one value only ever in one field. I want to display this value from this query in a form, but the query is not the record source. What's the simplest way to do this?
 
X

xyzer

To be clearer, my query has one field and only ever one record. The value of that record can change though, hence my desire to show it on the form.
 
J

John W. Vinson

X

xyzer

I actually tried that and no matter what I did to massage the dlookup the value did not appear in the box when I opened the form. I will get some more specifics tomorrow at work.
 

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

Top