Requery command in Forms

[deepakg27]

Hi Guys,

I am working on Billing database. I have two form frmBill & frmBillDetails, both have queries which need to run on the fly based on (new or updated) data entered by the user.

I am using Dlookup command to pass the arguments to the query and get the desired results.

Till here everything is fine. Now as i load the form query runs and returns the answer based on the current arguments, but when I enter new data or update nothing happens. To counter this I used requerry command in AfterUpdate event of the field TAX in frmBillDetails. But the problem is as soon the requerry runs the tab goes to the very first record of the current form. For Example in frmBillDetails, if I have 15 Sub details for the current sub form and I am making a change in 14 record, requery will move the focus to the very first record. Similar problem is being faced in frmBill, in that if I am working on bill number 35, after requery it will move to bill number 1.

I want to run the requery but keep the focus right where it was. Kindly help on how to achieve this. Thanks.



Regards
Deepak Gupta

[Missinglinq]

To Requery a Record Source and then return to the Current Record, where [UniqueID] is a Field unique to only one Record, you can use something like this:

Where [UniqueID] is Text

 Private Sub SaveRequeryReturn_Click()

Dim UF_Rec As String
   
   UF_Rec = Me!UniqueID
   Me.Requery
   Me.Recordset.FindFirst "[UniqueID] = '" & UF_Rec & "'"

End Sub

Where [UniqueID] is Numeric

 Private Sub SaveRequeryReturn_Click()

Dim UF_Rec As Integer
   
   UF_Rec = Me!UniqueID
   Me.Requery
   Me.Recordset.FindFirst "[UniqueID] = " & UF_Rec

End Sub

Not sure, from your description, exactly what you're doing, but if the 'desired results' involves calculations, as simply Me.ReCalc may be what you need. ReCalc does just that, reruns all calculations...without moving focus to the first Record.

Linq ;0)>

[deepakg27]

Dear MissingLinq,

Thanks for your suggestion. I have yet not tried the code provided by you. Will try and post if any problems arise.

BUT for now I would like to thank you for suggesting Me.ReCalc. It solves my problem and i am able to get the desired results. A big Thanks.

Regards
Deepak Gupta

[Missinglinq]

I thought that ReCalc might be the definitive answer, but just could't be sure from your description.

Glad we could help!

Linq ;0)>

[deepakg27]

Thanks for the help.