How to send a form in background

[Trisha]

Dear,

I developed one macro which will open one existing table in the ms access db to add a new row.
I created a command button in my form which will call the macro to open the table.

But the butoon is not working as expected.
On clicking the form buttom the table view opened by the macro in the background of the form.

I want the when the table view opened by the macro the form goes to the background of the table view and on closing the table view I can still see the form.

Please let me know if it is feasible.

[June7]

Why open table? Really should not work directly with tables or queries. Open forms and reports bound to table/query.

Try:

DoCmd.SelectObject acTable, "table name"

[Missinglinq]

As June7 said, use a Form to update the Table, and open the Form in Popup Mode, which will make it appear in front of the calling Form.

Linq ;0)>

[azhar2006]

Hello guys
Trisha ,
You committed a fatal error ??????????? !!!!!!!!!