Create new row in table

[Rafik O]

I am trying to create a database for the inspection of properties.
I have a created a table and form with the following 6 fields.

InspectionID Index Primary Key
PropertyAddress Address of the property Text
DateOfInspection Date of inspection format dd/mm/yyyy
InspectionDone Y/N tick box
InspectionBy Lookup
Comment Memo

What i am trying to do is initially for each property i will type in the information example in datasheetview
PropertyID PropertyAddress InspectionDate InspectionBy Inspecti
1 Gedding Road 73 08/04/2009 Ash -1
2 King Edward Road 25 06/04/2009 Salim 0
3 Trevino Drive 61 10/04/2009 Ash 0

What i am trying to do is once an inspection is done, and the box INSPECTIONDONE is clicked a new record is created in the next row with the following informatin

InspectionID to change to the next number up
PropertyAddress to stay the same
DateOfInspection to change to current date plus 3 months
InspectionDone to stay the same
InspectionBy to stay the same
Comment to stay blank

I hope you understand and help me sort out the code

Rafik

Ps for those who surf the forums I did post this elsewhere but have not solved the problem.