Query results as a Control Source for a Text Box on an unbound for

[WildlyHarry]

How do I use a query result as a Control Source for a text box on an unbound
form, without using a subform? I do not want to use a subform. Because I
want to use the results of the query in an expression in conjunction with
data entered by the user on the form. Also there is only one field and the
subform does not conform to the visual design ascribed to this form.

 

[Maurice]

Maybe you could use a Dlookup. Something like:

=DLookup("fieldname", "queryname", "wherestatement-optional")

place this in the unbound field on your form and replace the names between
the double quotes for your own field and queryname. You need to place the
double quotes around thenames though.

hth

 

[WildlyHarry]

Worked like a charm thanks

Maybe you could use a Dlookup. Something like:

=DLookup("fieldname", "queryname", "wherestatement-optional")

place this in the unbound field on your form and replace the names between
the double quotes for your own field and queryname. You need to place the
double quotes around thenames though.

hth