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
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Average columns based on value that I give 4
Select records based on isolated portion of string 1
Delete Query: Could not delete from specified tables 0
quandary on selecting certian records 4
Select Portion of a Text String 4
IF Statements - JCW 3
Update Query Problem 11

Back
Top