Re: Help with hiding/showing forms

From: Kate (anonymous_at_discussions.microsoft.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 15:15:55 -0700

The query is a select. How do I close the query?

Thanks

>-----Original Message-----
>Questions:
>What does the query run for? is it an update or append
query. By running a
>query from code it will display the query results. You
would need to close
>the query before doing anything else, as an open query
will stop all
>subsequent code.
>"Katie" <anonymous@discussions.microsoft.com> wrote in
message
>news:63ff01c42e2c$da14c710$a101280a@phx.gbl...
>> I have some code attached to a button on a form that
runs
>> a query, hides the form and then tries to show another
>> form. It hides the first form, displays the result of
the
>> query but doesn't show the second form. What am I doing
>> wrong?
>>
>> Also how do I stop the query result displaying?
>>
>> DoCmd.OpenQuery "QueryAv"
>>
>> ' 'Hide availability form
>> Forms![SINGLE BOOKING AVAILABILITY].Visible = False
>> ' 'Open the detail form
>> DoCmd.OpenForm "SINGLE BOOKING DETAIL"
>> ' '
>> Forms![SINGLE BOOKING DETAIL].Visible = True
>
>
>.
>