Delete Query Help

[Chad]

Hello, I would like to have a form with 5 text boxes that I would enter a
CoilID (pk)number in it and lets say txt1,txt2,txt3,txt4 and txt5 and a
button at the bottom of the form that gives me the option to delete the
records that are in the text boxs 1-5. Most of the time I will be only using
2 or 3 of the text boxes but I need a few extra just incase. Is this possibe
and if so how would I achieve this? Thanks!!

 

[Jeanette Cunningham]

Chad,
the usual way to do this easily is to create a form based on a query that
can show records from that table.
Make that a continuous form or a datasheet view.
Use a combo to filter the form if you have a large number of records in that
table.
Make sure the form has its Record Selectors property set to Yes.
For a record you want to delete, click its record selector and hit the
delete button.
I assume this is for yourself - not for other users.


Jeanette Cunningham -- Melbourne Victoria Australia