Help with hiding/showing forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Katie - 29 Apr 2004 21:59 GMT

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

Reply to this Message

Bill Taylor - 29 Apr 2004 22:30 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.

> I have some code attached to a button on a form that runs
> a query, hides the form and then tries to show another
[quoted text clipped - 12 lines]
> ' '
> Forms![SINGLE BOOKING DETAIL].Visible = True

Reply to this Message