Query Fields On Form

[MFS]

Is it possible to have a text box on a form with the value from a query field?


I would like to show a few query field values from multiple queries when the form is open.

[pbaldy]

Not directly, unless the query is the form's record source. You could use DLookup().

[MFS]

I guess I could try DLookup.
Thank you pbaldy

[pbaldy]

No problem.

[ItsMe]

Just to throw my two pennies....

Since you mentioned a few fields, I would consider a subform. I do this sometimes when I want the form to be capable of edits but still show other relevant info. I will format the subform in a way that it blends in with the rest of the form. The end result is the form has more than one recordsource. The main recordsource is updateable while the others, 9contained in subforms, are not. Yet, I can place any and all of the controls in any order I choose.