Problem with SQL statement getting value from query

[matt753]

I have the following SQL statement in a text boxes control source.

SELECT SumOfHours FROM qryHoursPerOrder WHERE OrderID =  [OrderID]

The query is a 2-row table with OrderID's on one side and SumOfHours on the right. I just need to return the SumOfHours for that order. I get a warning/error on the form: Invalid control property.

Is there something I am missing?

[Megalog]

If OrderID is purely numeric Then use:

=DLookUp("[SumOfHours]","qryHoursPerOrder","[OrderID] = " & [OrderID])

Else

=DLookUp("[SumOfHours]","qryHoursPerOrder","[OrderID] = '" & [OrderID] & "'")

End Help

[matt753]

Thanks that worked, I never thought to use DLoookup for some reason I was just trying SQL