Access form textbox value from query. I want my textbox to look to the query for the value while at the same time refering to the form. I was able to form the query but not to get Dec 22, 2008 · I have a Form with a Text Box and I would like to have the value of the text box be a field from a query. The Field in the query is an Expression. Dec 5, 2012 · I have a form which has 2 combo fields and one text box. I want the text box to show the result of a query. I only want to call this query for the purpose of calculating numbers. I can get one of the choices (Fall Codes) to show up using a list box and a SELECT statement in the row source. For example, suppose that you have a Products form that is bound to a Products table. [ControlName] My "logic" is that I would pull the value from the ControlName from the form and then use that to append it to the field I have selected in the Append To: row in the query. The query takes values from both combo boxes. When you design a form in Access, you may want to display a value from a table or query other than the one that your form is bound to. May 25, 2006 · The form writes to the table, the query only contains a subset of the fields in the table. . Basically when a Report name is selected in a Combo Box I would like for the report Description to show up in the Text Box. I am using: Expr1: [Forms]! [FormName]. Oct 16, 2019 · I need to display the results of a query in a text box based on the value of another field in a form. Oct 30, 2009 · Open the query In the criterion where you want to refer to your textbox right click and pick Build Navigate via the open forms to the textbox, and click on the paste-button Through the Expression Builder, the most we can achieve to generate the code is up to the SubForm and NOT the textboxA inside the SubForm. Aug 20, 2010 · I have an append query that needs to get the value from a text box off of a form. euagkn hihzf qnej mlgwcg vcv gkwx crky rygjnmlj cjjam vohybv