 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2008Insert a query result into a form or text box
Hello, I have a combo box of queries so when I choose a query it opens separately. I found a database with a dynamic form that places a query result into a text box. It is similar to what I would like but my queries are "totals" queries with calculated percentages. So what I would like is to use the after update event of the combo box to place the query result into a text box. What is the best way to go about doing this? cheers Probably not clear enough. I have a list of queries and I want to choose which query I show in the text box. thanks. If your query returns just one value, why not just use a DLookup?  SignatureDave Hargis, Microsoft Access MVP > Probably not clear enough. > > I have a list of queries and I want to choose which query I show in the text > box. > > thanks. Hello, I know I haven't explained myself very well This is the form I looked at. http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='DynamSubFrm.mdb' It is not too far from what I would like to have. The VBA code uses one SQL. My list of queries have different SQLs I have made some progress > If your query returns just one value, why not just use a DLookup? > [quoted text clipped - 4 lines] > > > > thanks. I am getting an error trying to go to the link you supplied. SignatureDave Hargis, Microsoft Access MVP > Hello, > [quoted text clipped - 17 lines] > > > > > > thanks. I managed to work it out. I had used a text box instead of a subform! > If your query returns just one value, why not just use a DLookup? > [quoted text clipped - 4 lines] > > > > thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.