How to insert a record/row at a specified value

Hi guys,

I've currently got a data entry form that inserts a record at the bottom of a list. The code was given and adapted, and so im not 100% sure on how to alter it.

Basically, each record has a 'step number', and all i want the user to be able to do is type in the fields, then say 'i want this to be step 4' in a list of say...10 records. Upon clicking 'add' i want a row to be inserted below row 3, and the fields copied accross accordingly.

Below is my current coding for the form.

Please Login or Register  to view this content.

The textbox that contains the Step Number is called txtStep.