Deleting A Record Based On A Value In A Text Box?

[Darla]

Hi everyone! I was hoping someone could help me with this. I have a form that's tied to a table. What I'm trying to do it to have a button that looks at the value of TextBoxA on the current form, and then finds that record in FieldA in the table then deletes it. I'm terrible at explaining things, so for example, I have my form up, and in TextBoxA I have a value of "7117". I want to delete the record in my table that equals "7117" in FieldA by clicking the button.




What is the best way to do this?

[Bulzie]

DoCmd.SetWarnings False
DoCmd.RunSQL = "DELETE FROM YourTable WHERE YourFieldInYourTable = '" & Me.TextBoxA & "'"

Just have a good backup of your data and test it well.

[orange]

Darla,

Delete queries can be very unforgiving.
Be very careful with your development and testing to ensure you have
a-- a backup of your database and/or table
b--tested your code as a Select query to ensure you get the correct record(s), once satisfied, change to DELETE query

Many systems do not physically delete records, they mark them with a flag eg: IsDeletedYN and use logic to treat records with IsDeleted = Y
as logically deleted.

Good luck.