Copying text from query to form

[Jedit]

Help please.
Don’t seem to be able to see the woods for the trees here????

Anyway.

I want to input a value from a query in to a textbox on my form.
The form is bound to a query called qry_datainput that does some calcs etc &
displays the data. The text box (form-time) takes input manually but I want
to get a value (sum-form-time) from another query called QRY_sum-fORM time.

How can I automate this function so that I don’t have to copy the value from
one form & paste it into the other????

code for query is bellow

SELECT DISTINCTROW QRY_Part_NPs.mc, Sum(QRY_Part_NPs.[Unit Time]) AS
[Sum Of Unit Time]
FROM QRY_Part_NPs
GROUP BY QRY_Part_NPs.mc
HAVING (((QRY_Part_NPs.mc)="FORM"));

 

[Dan Artuso]

Hi,
Why not use the DLookup function, I think it will work for you.
Help has examples.