Solved Focus on continuous form

[MajP]

Glad it worked. Again, you may want to look at the Emulated Split form. This provides a lot of functionality and less clutter since you do not have another form open.

 

[gemma-the-husky]

Generally I thought me.refresh did not requery the underlying data. Me.requery does requery the data, but places the active cursor back to the first record.

So I thought you had to store the current position, requery, and then restore the active cursor to the steed position.

 

[MajP]

Generally I thought me.refresh did not requery the underlying data. Me.requery does requery the data, but places the active cursor back to the first record.

So I thought you had to store the current position, requery, and then restore the active cursor to the steed position.

I believe that was what was suggested

Public Function PopUpDetails()
  Dim currentID As Long
  currentID = Me.Id  'Save current record id
  'edit record
  DoCmd.OpenForm "frmPopUpDetails", , , "ID = " & currentID, , acDialog
  'requery after edit
  Me.Requery
  'move back to record
  Me.Recordset.FindFirst "ID = " & currentID

End Function

Save record id
edit record
Requery after editing
return to saved record id

 

[MajP]

I think the bit about filters is a red herring

Yes that is why it took 23 posts to figure out what the real question was

If you open the popup as a dialog

The OP is unfortunately not doing this, for what reason I do not know. Instead the OP is keeping a second edit form open with a save button to push the continuous form to update. My suggestion was if you want to see both the edit/detail form and a continuous form at the same time, it is better to combine them using a "split form" approach instead of two open forms. Because the MS split form is crap, I recommend going with the @isladogs emulated split form.