Delete Record Based on Text Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set this up to work before with one text box, but I am struggling to make it work with 2

Is there a way to make a delete query that will delete any record in a table where the value in field 2 is equal to Textbox1 AND the value in field 3 is equal to Textbox2. It simply needs to delete the entire record based on these two textbox values being equal to the value in two fields.

Thanks for your assistanc

Jim
 
Is this a saved query? What is the SQL view?

--
Duane Hookom
MS Access MVP


James Stephens said:
I have set this up to work before with one text box, but I am struggling to make it work with 2.

Is there a way to make a delete query that will delete any record in a
table where the value in field 2 is equal to Textbox1 AND the value in field
3 is equal to Textbox2. It simply needs to delete the entire record based
on these two textbox values being equal to the value in two fields.
 
Back
Top