sub form insertion / right click

[vthomeschoolmom]

I have a form with a sub form that has a master record of data and a sub-form that is a grid of detail data. One of the columns on the sub-form is a number. I want to right click on the row in the sub-form and insert. I can click New Record for instance. Before inserting the new record, I want to be able to capture the current row's numeric column. I then want to increment the number for every row after that. The code to do that is easy. But I cannot think what event I need to do it on. Before insert fires after I have navigated away.

Tip anyone? Thanks

S

[June7]

Maybe form Click event to set variable, but only if the value is greater than current value of variable. I am assuming this is a global variable. I don't know how to make this a right click action.

I don't understand why incrementing value based on column number.

[vthomeschoolmom]

Basically, the detail grid contains a list of steps. When I insert a new row, I want the step #s to increment from that record on. The code to do the increment is trivial. What I cannot see is how to get the id of the current row before moving off it for insertion.

[June7]

What is the nature of this ID - a custom unique ID? You want the value of the ID that is in field of current record? Try the form click event and code to set a global variable or an unbound textbox on form to hold value.

[vthomeschoolmom]

I figured it out. Form_Current has

If Not IsNull(Me.Step_Number) Then lngLastTestID = Me.Step_Number

The value is not null if it is not a new record.

Then

I reorder the steps in Form_BeforeInsert. I would like to do it in whatever event immediately preceeds this. But this works well enough.