Check Boxes

[mnewton367]

Alright so basically I have tables with a bunch of data on each record and one of the fields is a check box. These tables are 'subTables' of a Form. I want to make it so when someone checks off a record in one of these tables, it moves to the next table respectively. And for the last table's complete check, it simply deletes. How would I go about this?

[ranman256]

If a user check marks the record, then do an update query and/or append query.
on the AFTERUPDATE of the check box:
upd the checked rec in tbl1.
append the checked rec to tabl2.

en continue until the last table is filled...then run a delete qry.

[mnewton367]

If a user check marks the record, then do an update query and/or append query.
on the AFTERUPDATE of the check box:
upd the checked rec in tbl1.
append the checked rec to tabl2.

en continue until the last table is filled...then run a delete qry.

Could you elaborate a little more on how to do update queries and append queries, and such? I'm trying to teach myself Access here, so I don't know the fine details that it's capable of.

[June7]

What do you mean by 'moves to the next table respectively' - what is the next table? What do you mean by 'complete check'? And delete what - just this one record?

[mnewton367]

So the main form has several subForm tables on it and each record in these tables has a 'Mark Complete' check for that 'item'. So the person using it can mark when that item is complete, it then moves to the next table for the next process. Then once complete, that record can then be checked complete and deleted.

[June7]

Record deletion should be a rare event. I don't understand why you want to delete records. Filter records instead of deleting.

Do you already have code for 'moving to next table'? Do you actually mean move to a subform?

[mnewton367]

Why is it 'rare' to delete records? What does filtering a record instead of deleting it entail?

No, I don't have code. I wouldn't mind trying to write it myself, but I don't know where I would put it.

[June7]

Because once a record is deleted, it is gone for good. Too often this is regretted after accomplished. Filtering would mean building a query that has filter parameter. But if you really want to delete, so be it. However, without understanding your db structure it is difficult to advise specifics. And yes, possibly the trickiest part of coding is figuring out what event to put it in.