opening form from a query

[webmagic]

Hello All,
I have a form which from a button opens a query. Once the query is open I have to close the form so the query is on top and can be veiwed. I created a macro to do that. But now when the user closes the form, I want to open the form again. I have tried to create a macro to do this and am not sure where to run it from.

Any suggesstions are appreciated.

 

[PaulJR]

I don't know why the query opens up underneth the form, it maybe that your form properties attribute for 'popup' is set to yes? in which case all other windows open up underneth. If this is the case changing the popup setting to 'No' may be all that is required.

 

[webmagic]

Thank you for the reply.

Nope-I checked that already-The pop-up is set to no. This is a form I created and had to make the form invisible when opening reports and then make visible when the forms close, and I can't figure out how to do the same things for queries. I am working in Access 2000.

Thanks again for your help.

 

[webmagic]

I got it fixed-It was a macro that was closing it-that someone had wriitten during one of the many revisions-thanks for your help.

 

[webmagic]

Well this isn't fixed.

I thought it was from the macro, but now I am not sure.

If I open the db and don't have the form open in startup then when I click on the button for the query to open the query opens on top of the form. If I make the form open on startup, press the button on the form to open the query the query is below the form and I have to close the form to view the query.

Any suggestions, and as always thank you in advance for any suggestions.

 

[PaulJR]

I haven't seen that happen before but I am quite new to Access myself. I'm not sure why having the form open at startup would cause the query to open behind the form!
I can only think it is something to do with the form attributes or the macro that displays the query, but I think you have already looked at these and my knowledge here is pretty basic I'm afriad.