Help with hiding/showing forms

  • Thread starter Thread starter Katie
  • Start date Start date
K

Katie

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with hiding/showing forms 1
I'm struggling with my limited knowledge of code 3
Using recordset I get errors 4
Help run time error 6
ByPass key ms access 2016 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Query with multiple results 1
Command button on one form opens a new form to same subject 2

Back
Top