Leave Opened Table on Top

[neosam]

Hi,
I have a form which has a button. The job of the button is to open a table. I ve done that but when the table opens, the form needs to be behind the table. In other words the form needs to be open but has to be hidden behind the table, so that when the table is closed, the form pops up from behind. Kindly help me with this.
Thanks

[MindBender77]

Hi,
I have a form which has a button. The job of the button is to open a table. I ve done that but when the table opens, the form needs to be behind the table. In other words the form needs to be open but has to be hidden behind the table, so that when the table is closed, the form pops up from behind. Kindly help me with this.
Thanks

You could try:
Adding code to the OnClick event of the button that minimizes your form.
Are you opening a form in datasheet view when you say your opening a table?

Bender

[neosam]

You could try:
Adding code to the OnClick event of the button that minimizes your form.
Are you opening a form in datasheet view when you say your opening a table?

Bender

I am opening the form in formview. That form has a cmd button which opens the table in datasheet view.

[missinglinq]

You keep saying that you are "opening a table." If this is true, you are making a grave mistake. End users should never have direct access to tables, but rather should interact only thru forms. Use the table as a basis for a datasheet view form (you can easily use the Forms Wizard for this) then go into Design View and go to the Properties sheet, Other tab and set Popup to True. Now have your button open the form, and it'll appear on top of the first form.

Welcome to TheScripts!

Linq ;0)>

[neosam]

You keep saying that you are "opening a table." If this is true, you are making a grave mistake. End users should never have direct access to tables, but rather should interact only thru forms. Use the table as a basis for a datasheet view form (you can easily use the Forms Wizard for this) then go into Design View and go to the Properties sheet, Other tab and set Popup to True. Now have your button open the form, and it'll appear on top of the first form.

Welcome to TheScripts!

Linq ;0)>

The end user of this application i am making is just one person who will make changes to the table frequently. Thats why i need the table to open in datasheet view when i click on the button. The problem i am facing is that the form stays in the forefront even when the table is open. The table still is accessible but it doesnt look good.

[Stewart Ross]

Hi,
...when the table opens, the form needs to be behind the table. In other words the form needs to be open but has to be hidden behind the table, so that when the table is closed, the form pops up from behind...

Hi. Check that the form's Pop-Up property is set to No. If it is set to Yes it will stay on top of all other open windows in your application.

-Stewart

[NeoPa]

When you have opened the table, you can run :

Call DoCmd.SelectObject(acTable, "TableName", False)

You can also hide the form, but triggering the showing of it again is quite fiddly. Let me know if this is important for you.

[NeoPa]

NeoSam, I've amended the title of this thread to conform to the site rules (See Help above). Please try to follow the correct format in future.

Welcome to TheScripts :)