Button to Delete Certain Records in a Table

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

Guest

Hey I have a table with 4 different fields per record. On my switchboard I
have a command button that when clicked deletes all the data in that table
for all 4 fields. How can I create a button instead that will only delete all
the data in 3 of the 4 fields for all the records throughout my table? Thank
you for your help in advance.
 
Use an Update query to update the fields to Null.

1. Create a query using this table.

2. Change it to an Update query (Update on Query menu.)
Access adds an Update row to the grid.

3. In the Update row under Field2, enter:
Null
and do the same under Field3 and Field4.

4. Save the query.

5. Set up your button to run code or a macro that executes this query.
 
Allen

So how then, after using this method, can I delete the empty row from the
table?
I'd like to delete to fields from a two field table(the entire record).

Thanks
 
Back
Top