By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Stay OnTop - Query

P: n/a
I have a form that by pressing a button, it opens up a query. I then
have the code to close the initial form. Then, this put the query
behind the main menu. Is there a code to add for this?:

DoCmd.OpenQuery "Query1"

DoCmd.Close acForm, "Form1"
By the way, I need "Form1" to stay open for "Query1" to open... then
once it is open, I want "Form1" to close and yet, "Query1" to stay on
top of all other forms. (e.g. Main Menu")

I don't want to create a form and have a datasheet view at this time.

Thanks,
Perry
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Try adding this to your open query statement. I tried it and the query
stayed in front of my main switchboard.

DoCmd.OpenQuery "Query1", acNormal, acEdit
--
Reggie

www.smittysinet.com
----------
"PerryC" <pe******@yahoo.com> wrote in message
news:ea*************************@posting.google.co m...
I have a form that by pressing a button, it opens up a query. I then
have the code to close the initial form. Then, this put the query
behind the main menu. Is there a code to add for this?:

DoCmd.OpenQuery "Query1"

DoCmd.Close acForm, "Form1"
By the way, I need "Form1" to stay open for "Query1" to open... then
once it is open, I want "Form1" to close and yet, "Query1" to stay on
top of all other forms. (e.g. Main Menu")

I don't want to create a form and have a datasheet view at this time.

Thanks,
Perry

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.