Set Foxus - i think

[TheCandyman]

I have a MS Access DB which loads a simple pop up form. Once a button is clicked, it runs VBA code to open a query. Problem is, the form stays in front blocking the users view.

My thoughts to fix this are two ways:
1- minimize the form, but can a query run VBA when closed?
2- set focus which bring the query on top of the form.

Is either of these possible? Which is best?

 

[dhookom]

It could be the simple pop up form needs to be set to invisible in order to see whatever is behind it. However, I would use the query as the record source of a form and open the new form in acDialog mode.

Duane
Hook'D on Access
MS Access MVP

 

[TheCandyman]

You mentioned pop up and got me thinking and I did some testing. It appears if you size the form in a pop up (not full screen) it always stays on top. In the properties menu on that form, if you change (on the Other tab) the pop up to 'No' then the form starts in full screen. Having it in full screen allows it to switch to the back and the query to the front; they are all listed as tabs in Access 2007. That workaround will work. It's not as pretty as a nice specific size... but it works.