Delete Records in Form Upon Close

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VLee.KHer@gmail.com - 21 Nov 2005 20:35 GMT

Greetings,

I am trying to delete records from a form upon closing of the form if
the record has been updated using a toggle button. Would it be easier
just to run a delete query for this? Is it possible to delete upon
close?

Thank you in advance,

VLee.KHer

Reply to this Message

Tim - 21 Nov 2005 20:52 GMT

I would create a delete query, set the criteria for it to run, and then
create a macro that would close the form then run the qurey.

>Greetings,
>
[quoted text clipped - 6 lines]
>
>VLee.KHer

Reply to this Message

Pat Hartman(MVP) - 21 Nov 2005 21:19 GMT

Forms don't hold records, tables hold records. Are you talking about
deleting the single current record or are you talking about deleting records
which have been flagged in some way by the toggle button?

> Greetings,
>
[quoted text clipped - 6 lines]
>
> VLee.KHer

Reply to this Message

John Vinson - 21 Nov 2005 23:48 GMT

>Greetings,
>
>I am trying to delete records from a form upon closing of the form if
>the record has been updated using a toggle button. Would it be easier
>just to run a delete query for this? Is it possible to delete upon
>close?

Well, considering that records are not stored in forms, if you do mean
to use the plural (deleting multiple records) then yes, a Delete query
is essential.

I'm curious why you would want to do this. It sounds like you're using
the form to create or edit a record in the table, and then discarding
that record... am I misunderstanding?

John W. Vinson[MVP]

Reply to this Message