Requery Form after adding new record

[ejmiller2]

Hi all,


I've posted this quetion in a different thread but have a much better grasp on it, so decided to start a new thread. I am trying to Requery a Form which brings the record set to the first record. I need it to stay on that record after updating the form so i've used the bookmark (and tried absoluteposition). This code is pasted into the Afterupdate on a combo box.

VarBKM = Me.Recordset.AbsolutePosition

Me.Form.Requery
Me.List4.Requery

On Error Resume Next
Me.Recordset.AbsolutePosition = VarBKM

This works great, until I add a new record. It seem that the new record has not "officially" been added so when I try to bookmark it or get the recordsets absoluteposition before requerying the form, it's retrieving the first record. Thus, when I set the position of the record, it goes to the first record. Anyone have any suggestions?...
Thanks,

Eric

 

[ejmiller2]

well i didn't solve the problem, but i did find a solution. Instead of requerying the form i just decided to requery the Recordset. I guess I was overdoing it with a form requery.

eric