Re: Help with hiding/showing forms

From: Bill Taylor (wtaylor51537_at_earthlink.net)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 21:30:04 GMT

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