Refresh

[duvenhlc]

I requery a form when a "pop up" form closes, on the "close" command. How do I then reurn to the original selected recordset on the main form? The reocord I used to open the "pop up", it returns to the first record when I requery. Refresh is not working, since the main form needs to do a calculation on the requery command.

 

[Galaxiom]

Save the key for the current record as a variable and use the FindRecord Method when you return to the form.
http://msdn.microsoft.com/en-us/library/aa189828(office.10).aspx

 

[missinglinq]

Where [UniqueField] is a field unique to only one record.

Where [UniqueField] is Text

Dim UF_Rec as String
   
   UF_Rec = Me!UniqueField
   Me.Requery
   Me.Recordset.FindFirst "[UniqueField] = '" & UF_Rec & "'"

Where [UniqueField]is Numeric

Dim UF_Rec as (Fill in number type here)
   
   UF_Rec = Me!UniqueField
   Me.Requery
   Me.Recordset.FindFirst "[UniqueField] = " & UF_Rec

But let me ask; are you doing the Requery just to get the calculation done? If so you can use Me.ReCalc instead.