Undo creation of new record in subform from mainform 1

[Kalin]

made a button on a mainform which has to cancel a newly made record on a subform. Problem is focus to subform is lost and thus undo doesn't work.

By the way, after undoing the focus has to be set to an empty new record.

 

[GBall]

I haven't checked this, but I think that subform_name.undo should work.
As you had to be at an empty new record to undo the changes, you should be lkeft with the emopty record again.
hope this helps,
Graham

 

[CPUburn]

hi there:

try this one out:

Dim rcs_a As Recordset
Set rcs_a = Me!Child0.Form.RecordsetClone
rcs_a.MoveLast
rcs_a.Delete
Me!Child0.Form.Requery
Me!Child0.Form!Text0.SetFocus
'' then in the gotfocus you can go to a new record...

grtz

CPU-burn

 

[Kalin]

Thanks CPU-Burn.

It worked......