Moving record to another form

[fwg]

Alright, I am new to Access, so forgive me if this is a simple question.

I have a form that has numerous records in it. They are invoices. I want to move the records to another form when they are paid. I just set up a check box to mark whether or not they are paid. My question is how to I make the record move to another form when I mark the check box?

Any help would be greatly appreciated.

Thanks,
Patrick

 

[mark curtis]

Ensure your invoice form is built on a query and only return the records without an entry in the check box.

For a form that only shows invoice paid use a query with the check box checked.

OR

To be neat what you can do is build the form on a query and then have a check field on the form that shows paid or not paid. On selection of the field you can then requery the form.