Do something after datasheet view closed?

  • Thread starter Thread starter David
  • Start date Start date
D

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.
 
David said:
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.
Click to expand...

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.
 
How would I do that?
I like the opentable in datasheet view method because it
is just one statement.
 
David said:
How would I do that?
I like the opentable in datasheet view method because it
is just one statement.
Click to expand...

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.
 
Back
Top