Im very new to access and VBA so pardon my lack of knowledge.Can you please elaborate?
Are you looking to do something in the form's BeforeUpdate to make a copy of the record?
The DB was built by the previous employee so im unaware of some things, but the form is in continuous mode yes.Is that a form in continuous mode?
If so, you would want to use a button instead of a check box.
Important design question, what is different between your "Shipped" and original tables? Shipped would normally be a status for a line item (or a child record that shows how much was shipped and when) so you would normally never delete from the original table.
Can you please show your table layout and describe what you are trying to accomplish?
Not that the way you are doing it can't be done, but I'd rather make sure you are doing this in a way that causes you as few issues as possible.
Hi. To unclutter the orders menu, all you should really need to do is modify it's query to filter out the shipped orders. There's rarely any need to create a new table and move the data there.The DB was built by the previous employee so im unaware of some things, but the form is in continuous mode yes.
I don't have a "shipped" table yet, but im hoping to get the data to go from this "orders menu" form and be transferred to a "shipped orders" form or table.
EDIT: The reason for this is the orders menu is very cluttered and my supervisor wants the orders menu to only consist of non shipped orders, and wants all the shipped orders to be stored somewhere else.