new record vba if

[ENEMAL]

I have two tables. TblClassess and Tblstudent

Tblclass has these fields (pk_ classid, classname , year)

Tblstudent fields are stdID , FK_classid , studentName , status, others

The two tables are related by pk_classid and FK_classid

Now I have a main form base on Tblclass and a subform from student table

I want to create a new record in the main form and duplicate the subform records if status = "regular"

If the year in the main record is 2013 the newly created record should be plus one that is 2014
and before creating new record a message box should appear " do you want to continue". If yes create new record. If no don't create anything

Any vba help please

 

[Mihail]

Upload the database

 

[ENEMAL]

Having read about table relationship, i discovered that my schema was wrong . I will have to start a new thread regarding that. Thanks for all your response .