Delete Record Based on Text Box

J

James Stephens

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
 
D

Duane Hookom

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