hi
how can i assign the value returned by a query as a value to be displayed in a control? in this case the form already has a different table as the control source

i uased a select statement but i cannot assign the value to the control.