Thread: Query help
View Single Post
  #2  
Old June 2nd, 2010, 07:46 AM posted to microsoft.public.access.gettingstarted
xps35
external usenet poster
 
Posts: 22
Default Query help

=?Utf-8?B?UmljaGFyZA==?= wrote:


I have a form with (2) textboxes StartDate & EndDate also a command button.
When the command button is pressed a query captures the (2) dates and then
displays the correct results. I would like to see the results in a listbox
instead of a query window. The code behind the button is wizard created:

DoCmd.OpenQuery "Qcalendar", acViewNormal

Thanks


Let the query be the RowSource of your listbox and change the code
behind the button to:
Me.YourListbox.Requery

--
Groeten,

Peter
http://access.xps350.com