|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 5th, 2008, 05:46 PM
posted to microsoft.public.access.forms
|
|||
|
|||
#Name? Error - On text box
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 
|
|
#2
June 5th, 2008, 05:52 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name? Error - On text box
"iholder" wrote in message
... 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) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!)
|
|
#3
June 5th, 2008, 07:18 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name? Error - On text box
Thank for the tip for future reference. It work just fine.
Ileana "Douglas J. Steele" wrote: "iholder" wrote in message ... 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) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
