Do something after datasheet view closed?

[David]

Is there any way to open a table in datasheet view and
code another statement after the opentable that will be
executed when the datasheet is closed.

For instance:
opentable ....
openform ....

If I do this, both the datasheet view and the form open
immediately. I want to do this but only have the second
statement execute when the datasheet edit has finished.

 

[Rick Brandt]

Is there any way to open a table in datasheet view and
code another statement after the opentable that will be
executed when the datasheet is closed.

For instance:
opentable ....
openform ....

If I do this, both the datasheet view and the form open
immediately. I want to do this but only have the second
statement execute when the datasheet edit has finished.

Use a datasheet view *form* instead of opening the table. Table and query
datasheets are not intended to be used as an interface and thus have no events
for stuff like this whereas forms and reports do.

Once you are using a form instead of a table you can use its Close event to open
the second form.

 

[David]

How would I do that?
I like the opentable in datasheet view method because it
is just one statement.

 

[Rick Brandt]

How would I do that?
I like the opentable in datasheet view method because it
is just one statement.

Yes, but it has a downside. It won't work for what you want to do. All you
need are two lines of code. One that opens the first datasheet form and one
that opens the second form in the close event of the first.