Macro to move completed order to another form.

[Tylerluk1]

Hi,

I have created an access database to track orders through out production. I have also created a form labeled "orders" with a subform where it has all the orders information, customer info and product info. Along with this there are 3 check boxes for each order they are labeled, "Routed", "Pressed" "Finished". I am looking for a macro for when I click the "finished" check box that order is moved to another form to reduce the amount of clutter on the orders form. Is there anyway to do this?


Thanks

Tyler

[ranman256]

you dont 'move' records to other forms. Forms show data from a query.
You can mark data where another forms query shows it there.

frmActiveRecords, the query will show records where [status] = "Open"
and
frmClosedRecs , the query will show records where [status] = 'Closed'

just mark the record, theres no 'moving'.