Delete a record and transfer to another record.

[nachoz88]

Hi guys, please answer ASAP!!!!


I have 5 tables...

• Form 1 class list this has student number, first name, second name class
• Form 1 term 1 marks this has student number, math_term1, eng_term1 etc
• Form 1 term 2 marks this has student number, math_term2, eng_term2 etc
• Form 1 term 3 marks this has student number, math_term2, eng_term2 etc
• Form 1 leavers

I would like to design a form with a combo box(where you choose the student number) and a button only that when you press it deletes that students records completely from the first 4 tables and take them to the form 1 leavers table so that you can still refer to the students marks at a later date but he is not considered in other calculations.

i want the form 1 leavers table to have the following fields : first name, second name, class, math _term1, math_term2, math_term3, etc...


Is this possible? if not what do you suggest i do is i want to delete a students records but then store them elswhere for any future reference

[ItsMe]

You say you have tables and then list out forms in the description?

[nachoz88]

okay in my country we have the 8-4-4 school system...
so form 1 is a class not an access form. it is the equivalent of grade 9

so basically its kind of the same as this :

• grade 9 class list this has student number, first name, second name class
• grade 9 term 1 marks this has student number, math_term1, eng_term1 etc
• grade 9 term 2 marks this has student number, math_term2, eng_term2 etc
• grade 9 term 3 marks this has student number, math_term2, eng_term2 etc
• grade 9 leavers

[ItsMe]

I don't know if I can help. The way I understand records is that they reside in tables. One row represents a record that is within one table.

I understand a form to be a Graphical User Interface. When a form is open, the user can see a recordset that represents records in one or many tables.

Your posts do not provide a statement that I understand other than you need help as soon as possible.

[ItsMe]

Perhaps if you delete all of the private data and zip down an example, you can upload a copy of your DB here.

I may not have the time to look at it but there is a chance someone else may.