forms in overlapping windows instead of tabbed.

[vicsaccess]

I'm trying to put together a DB with overlapping windows rather than tabs mainly because I think it looks better. I haven't done this in a while and I'm having a small problem. The forms are coming up on top of each other just fine but when I run a form to open a query the form still stays on top and you don't see the query. how do I correct this?

[ItsMe]

Bind a form to the query and open the form in DS view.

[vicsaccess]

tried it, not the look i'm going for. is there not a way to make my main form aways in back and everything including queries pop on top of it?

[CJ_London]

investigate using the form popup and modal properties - google to find out more or see this link

http://www.access-programmers.co.uk/...d.php?t=179101

[vicsaccess]

will they work on queries? i'm using them on my forms now.

[CJ_London]

no - you should not display queries directly - everything should be through forms or reports

If your form has enough space to have a subform to display the query results, do the following:

1. Create a subform on your form, delete the subform sourceobject property if there is one and call the subform control say QuerySF
2. instead of having code to open the query as you have now, use the following code

QuerySF.SourceObject="Query." & myQuery

where myQuery is the name of the query you have been opening