Query that opens as pop up

[Beat]

Hello,

I made a button on my switchboard that runs a filterquery. When I press it a tabel opens. The problem is is that the tabel opens behind my switchboard (so you can't see it). How can I make the tabel open like a pop up? Do I have to do that in SQL?

I hope someone can tell me where to look. Thanks!

 

[Big Pat]

This MIGHT be happening because you have set the Modal property of your switchboard form to Yes. Do you have any other forms or queries that open while your switchboard is open and do they "pop-up"? As far as I know a form with Modal=Yes will always be on top, so if you change that setting, your query might display normally. Just guessing, but worth a look!

 

[Beat]

I have modal on "no", I already had that. The thing I don't understand is is that I can change the pop-up setting on forms, so that they pop-up, but I can't find out how to do that on tabels. Got an idea?

 

[Big Pat]

I don't think you can. Tables aren't really meant to be a "display" item so i don't think they have that property.

But you can build a form on your table or query, and set the default view to datasheet. Then it will look like a table. And you can set the mdal property on it.