How to point to recently Added record in Continuous form from Entry form
Posted on 2008-10-07
I have a continuous form that the user can select a record and click on Edit or Add and it will open an Entry form.
If the record is edited, once the entry form is closed, the pointer will be on the record worked on.
If a record is added, once the entry form is closed, the pointer will be on the first record on the continuous form.
How can I make it point to the new record in the continuous form ?
The following is my code:
Private Sub Command28_Click()
On Error GoTo Err_Command28_Click
Dim intIDSelected As Integer
If IsNull(Forms![frmbuyersowners]![id]) Then
intIDSelected = 0
intIDSelected = Forms![frmbuyersowners]![id]
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
' this points to the edited record
If intIDSelected <> Me.id Then