 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / June 2007Show Query Results in a Form View
I have a query whose criteria are provided through a form. The query runs successfully. however, I would like to clean up the results and show them to DB users in a form as well. Unfortuately, I have not been able to figure this out on my own. Thanks in advance for the help. I appreciate your support and assistance. > I have a query whose criteria are provided through a form. The query > runs successfully. however, I would like to clean up the results and [quoted text clipped - 3 lines] > Thanks in advance for the help. I appreciate your support and > assistance. Create a form and bind it to the query. If you select your query in the db window and press the AutoForm button it will quickly create a form bound to your query. All you have to do is change the layout to what you want.  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Hello Rick, Thanks for the starting point! One final piece to the puzzle should get me going. Is there a way then to get the query results to appear in the new bound form, instead of datasheet view? > > I have a query whose criteria are provided through a form. The query > > runs successfully. however, I would like to clean up the results and [quoted text clipped - 9 lines] > will quickly create a form bound to your query. All you have to do is > change the layout to what you want. > Hello Rick, > Thanks for the starting point! One final piece to the puzzle should > get me going. Is there a way then to get the query results to appear > in the new bound form, instead of datasheet view? Just don't set the form's default view to datasheet view. Are you opening the form or the query? You need to open the form. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com My appologies. The problem is in my description. I would like to enter the query criteria in a search form, then click a search button on the form that runs the query and finally have the results of the query show in another form instead of in a datasheet. If I simply use the bound form, as you suggest, I have to manually enter the criteria in the perameters input popups and I'm trying to aviod that if possible. Thanks again. I look forward to your reply. The next beer is on me. :) > > Hello Rick, > > Thanks for the starting point! One final piece to the puzzle should [quoted text clipped - 3 lines] > Just don't set the form's default view to datasheet view. Are you opening > the form or the query? You need to open the form. > My appologies. The problem is in my description. I would like to > enter the query criteria in a search form, then click a search button [quoted text clipped - 4 lines] > enter the criteria in the perameters input popups and I'm trying to > aviod that if possible. No you don't. If you leave your query exaclty as it is (pulling criteria from form1) and then have the button on form1 open form2 (bound to your query) then form2 should show the result of your query. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Thanks for your time and patience. This has helped tremendously. > > My appologies. The problem is in my description. I would like to > > enter the query criteria in a search form, then click a search button [quoted text clipped - 8 lines] > from form1) and then have the button on form1 open form2 (bound to your > query) then form2 should show the result of your query. |
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.