Opening a form when closing a table

[thewaterguy]

In Access 2003 it possible to open a specific form upon closing a table? There doesn't seem to be any events tied to a table.

 

[bubba100]

It is not a good idea to access your data by opening a table, you should use a form to access the data.

 

[missinglinq]

That's correct! No events are tied to tables. Allowing users direct access to tables is considered very poor design practice! You need to create a form for your users to access the table, then open your second form when you close your first form. You can do this in about 30 seconds using the Forms Wizard, and selecting Datasheet as the style when asked. The resultant form will look like a table to your users, but have all the capabilities that a form has but a table doesn't.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[TheAceMan1]

How are ya thewaterguy . . .

The answer is no! . . . why! . . . [red]there are no events/triggers for tables![/red]

As suggested by [blue]bubba100[/blue] & [blue]missinglinq[/blue], if you view the table thru a form you'll be well on your way.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[JoeAtWork]

Has anyone mentioned yet that users shouldn't open tables directly?

 

[ProgramError]

Yes!


Ian Mayor (UK)
Program Error
Always make your words short and sweet. Because you never know when you may have to eat them.