as you can see the index shows 43 instead of 48 after i have entered  the question crieria on the after event

Your clone code copies from the previous record in the form's recordset order. If it is picking up 43, then the record containing 43 is the previous record as far as Access is concerned.

Make sure the form has an explicit, stable sort order. Don't rely on the table's apparent order. Set the form's Record Source query to include an ORDER BY clause using the field(s) that determine the order you see on screen, such as:

ORDER BY SectionID, QuestionNumber

Also, this line doesn't test whether NumIndexSection already has a value:

If Me.numIndexSection = True Then Exit Sub

Since NumIndexSection contains numbers like 43 or 48, use this instead if you only want to fill it when it is blank:

If Not IsNull(Me.numIndexSection) Then Exit Sub

Once the form is explicitly sorted correctly, MovePrevious should retrieve the value from the row immediately above the current one.

Hi
I don't mean rude ask this, but have you got a file that demostrates what i'm achive vira VBA, becuase only one have is the short key crrtl+'
i could do this mannually but i want hide the field once i'm satisfied that it's doing what i intended it to do.
the field

I don't have a sample file specifically for that, but the code you posted is essentially how I would do it: use a RecordsetClone, synchronize it with the current record using the Bookmark, move to the previous record, and copy the value.

The important part is that "previous" only has meaning when the form's Record Source has a defined ORDER BY. Once you add the correct ORDER BY to the form's query, your code should copy the NumIndexSection value displayed directly above the current record, just like Ctrl+'.

Also, make sure you're testing for a blank value, not True:

If Not IsNull(NumIndexSection) Then Exit Sub

After you've confirmed it works, you can set the NumIndexSection control's Visible property to No. The field can remain in the form's Record Source even if the control is hidden.