Remove row when I check a completed box

I have a box subform that tracks actions, action description and a completed box.  I would lik e to check a completed yes/no box and have the row it was on removed/deleted.  HOw would I go about doing this.  See attached database.
1st.accdb
lehi52Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
test this

1. created a query  "Q_ActionsAndOpps"
2. changed the Record Source of form "actions and opps"
3. add event procedure for the afterUpdate event of check box "Completed"
2nd.accdb
0
 
lehi52Author Commented:
Rey, you are a great help and know what you are doing.   Thank you very much.   It works great.
0
 
lehi52Author Commented:
Quick follow up.  How do you make it so that it displays only one line.  I tried it and it keeps changing so that it shows one line, then half of the second line.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.