S
Skipper27
I have a query that connects to an external order database an
retrieves all new, open, & changed orders. When an order ha
been changed (cancelled), a msgbox appears saying that orders hav
been changed and the Change Report should be run...Ok, so the use
runs the Change Report and gets a list of all changed (cancelle
orders). What my user then has to do is manually delete ever
cancelled order from the main form!! That could amount to dozens o
orders and is a very inefficient way to handle deletions...What
want to do is provide some way for the deletions to happe
automatically. For example, hav
cmdDeleteCancelledRecords that on clic
deletes records whose [b:4d2fb64414]Comment[/b:4d2fb64414] i
"Cancelled MFG Requirements...
How do I do this? :
retrieves all new, open, & changed orders. When an order ha
been changed (cancelled), a msgbox appears saying that orders hav
been changed and the Change Report should be run...Ok, so the use
runs the Change Report and gets a list of all changed (cancelle
orders). What my user then has to do is manually delete ever
cancelled order from the main form!! That could amount to dozens o
orders and is a very inefficient way to handle deletions...What
want to do is provide some way for the deletions to happe
automatically. For example, hav
cmdDeleteCancelledRecords that on clic
deletes records whose [b:4d2fb64414]Comment[/b:4d2fb64414] i
"Cancelled MFG Requirements...
How do I do this? :