Find a record

[orna]

Hi
I have a sub form on a tab control.
Double Click on this form calls a detail form.
when exit the detail form - it requery the sub form to update it.
I would like to get back to the record i stood on before .

TIA

 

[GKChesterton]

Do I understand correctly?
1 Start in a continuous form (multiple records)
2 Select a record on that form
3 Open a detail form for the selected record
4 Requery the continuous form to show changes
5 Go to the record selected in Step 2

You need to make use of recordsetclone and bookmark. Try 'Help' on those words.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[MajP]

I would not try to use a bookmark as suggested

Requerying a form invalidates any bookmarks set on records in the form.

use findfirst. Example

Private Sub EmployeeID_Click()
  Dim empID As Integer
  Dim strWhere As String
  empID = Me.EmployeeID
  strWhere = "EmployeeID = " & empID
  'code execution stops when you open a dialog form
  DoCmd.OpenForm "frmEmployees", , , strWhere, , acDialog
  'code execution resumes when dialog form closed
  Me.Requery
  Me.Recordset.FindFirst strWhere

End Sub

 

[orna]

Thanks GKChesterton & MajP
GKChesterton, that's right, The requery performed after changes in the detail form, when it is closed,
but i don't know where to insert the code to return to the line. Only the On Current Triger fires when it is back to the subform.