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
|
|||
|
|||
Display query result in Form
Morning,
Running Access 2002. Have built a form for user to enter a mode, an origin zip, and destination zip. Form has control button to run a simple query to return a rate for that shipping lane. I want to display the result of the query on the form. Have asked internal users, but no assistance available. The query works and pulls back a result, but how do I get it to display? Would prefer not to write code (don't know how) but have a user here I can utilize. Any help MUCH appreciated. |
#2
|
|||
|
|||
Display query result in Form
Is the form actually displaying different records that are stored in some
table(s) or is it just used to show the calculation? If the former, you could base your form on your query. That is, include the fields mode, origin zip, and dest zip in your query, along with the calculated field, and then use this query as the recordsource for your form. If the latter, you will probably want to use code. In the OnClick event of the button, say something like: me.txtShipRate = me.cmbMode *1.2 +( me.txtDestZip -5) blah blah, where txtShipRate is the name of the textbox on the form, cmbMode is a combo box (I'm assuming you use a combo box to choose a mode), etc. hope this helps -John "Ray M" wrote in message ... Morning, Running Access 2002. Have built a form for user to enter a mode, an origin zip, and destination zip. Form has control button to run a simple query to return a rate for that shipping lane. I want to display the result of the query on the form. Have asked internal users, but no assistance available. The query works and pulls back a result, but how do I get it to display? Would prefer not to write code (don't know how) but have a user here I can utilize. Any help MUCH appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Move feild entries from form to form using global variables | JackCGW | General Discussion | 11 | November 14th, 2005 05:22 AM |
Display the result of a query in a text box on a form | D | Running & Setting Up Queries | 2 | October 21st, 2005 02:39 AM |
Display result of query in text box on form | eacollie | Using Forms | 5 | October 6th, 2005 12:59 PM |
How to display result of query on a form in Access? | Aina | Using Forms | 1 | October 4th, 2005 06:37 PM |
Conversion | SVC | Worksheet Functions | 9 | February 28th, 2005 02:29 PM |