Control Source = to Query Value

[Matt]

I am trying to set the control source property for a text box to equal the
value from a query. The way it works is if I select a value in my form, the
query finds the Max(Total) for rows containing that value selected. After I
select that value I want the Max value to appear in a text box in the same
form. When I set the Control Source to equal the query value, all I get is
#Name?. Any idea how to fix this problem?

Thanks,
Matt

 

[Ken Snell [MVP]]

Try using the DLookup function to get the desired value from the query.