O
Old engineer
I have a split form designed that allows the user to select a previously
entered order from a list, then enter the actual ship date using a pull down
calendar. I would then like to use a control button to remove the associated
items from the inventory table, append the order information in a order
history table, and delete the order from the order table. I have each of the
queries working to accomplish these 3 tasks but cannot seem to get them to
run from the form. It does not appear that a delete record query will run
from a form. What is the best way to do this?
entered order from a list, then enter the actual ship date using a pull down
calendar. I would then like to use a control button to remove the associated
items from the inventory table, append the order information in a order
history table, and delete the order from the order table. I have each of the
queries working to accomplish these 3 tasks but cannot seem to get them to
run from the form. It does not appear that a delete record query will run
from a form. What is the best way to do this?