#Name? Error - On text box

[iholder]

I am trying the bind a query to a text box source control. I am using the
Expression Builder to the following in the source control.

[qryLastBoxAssign]![MaxOfBoxNo] .


There is another query being used on the Form source control. Can two
different query be used on a form.

I am trying to pull a value from another query not on the Form source control.


Thank You
Ileana

 

[Douglas J. Steele]

I am trying the bind a query to a text box source control. I am using the
Expression Builder to the following in the source control.

[qryLastBoxAssign]![MaxOfBoxNo] .


There is another query being used on the Form source control. Can two
different query be used on a form.

I am trying to pull a value from another query not on the Form source
control.

You can't.

Instead, try setting the ControlSource property to:

=DLookup("[MaxOfBoxNo]", "[qryLastBoxAssign]")

(Including the equal sign)

 

[iholder]

Thank for the tip for future reference. It work just fine.

Ileana

I am trying the bind a query to a text box source control. I am using the
Expression Builder to the following in the source control.

[qryLastBoxAssign]![MaxOfBoxNo] .


There is another query being used on the Form source control. Can two
different query be used on a form.

I am trying to pull a value from another query not on the Form source
control.

You can't.

Instead, try setting the ControlSource property to:

=DLookup("[MaxOfBoxNo]", "[qryLastBoxAssign]")

(Including the equal sign)