Is there a way to run a query when a table is closed. I know information
should be added throught a form, but necessity dictates adding right into a
table at this time. I want to run a check duplicate query each time the
table is closed.

TIA

--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf

No, there's nothing like that available in Access.

I can't imagine why, though, you must use the table: it would only take a
matter of minutes to create a datasheet form.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Cyberwolf" <(E-Mail Removed)> wrote in message
news:2CA204C6-14BB-41A7-8C93-(E-Mail Removed)...
> Is there a way to run a query when a table is closed. I know information
> should be added throught a form, but necessity dictates adding right into
> a
> table at this time. I want to run a check duplicate query each time the
> table is closed.
>
> TIA
>
> --
> Cyberwolf
> Finder of Paths, Hunter of Prey
> Ghost of the Night, Shadow of Day
> The Wolf

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in
news:#(E-Mail Removed):

> I can't imagine why, though, you must use the table: it would only
> take a matter of minutes to create a datasheet form.

Didn't MichKa once allude to the fact that table datasheets had
events, too, and you could attach event handlers to them using the
Immediate window?

I'm not recommending this -- I'm just saying that I have a foggy
memory that perhaps it's not as impossible as you say.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/