Delete Function

[Acidburn]

Adding a delete functioon??

Hello basically i wish to allow my end user to be abale to delete stuff (records) from the d/b.

Desriered outcome:

I would like the user to be able to select in a userform which of the enteries he wishes to remove, perhaps by using the yes/no function, i've messed around but had no luck since of linking tables . . .can it be done? if so could somene perhaps have a go, i've included the file

http://zatrixsolutions.com/ex/db.zip

thanks all

Acidburn

 

[Kraj]

There are oodles of ways to make record deletion routines, and I can't say which is the best. But the easiest would probably be to add a yes/no field to the table, create your form that lists record entries with the yes/no field available. Then make a delete query to delete all records and related records that have the box checked.

 

[Acidburn]

how would go about doing that? i've included the yes/ no filed and now ive got to the point where i build my form, do I desgin the form based on the table i wish to delete from? Or do i build a the delete query and base it on that?

 

[Acidburn]

bump,

I've tried searchin the foums but no luck Basically i need a form that lists everything in tblPcSpec and the user can select which records needs to go by using the Yes/No feature howver i made a delete query but it keeps deleting the entire records regardless if i tell it yes or no. Any ideas??