Delete Records in Form Upon Close

V

VLee.KHer

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
 
P

Pat Hartman\(MVP\)

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?
 
J

John Vinson

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?
Click to expand...

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]
 
Top