I am moving access qrys to stored procs in sql server. Any recomendations on how i should handle the DLOOKUP function ?
Any help on how should I replace all the below DLookups with single stored proc with output parameters.

Private Sub Borrower_Exit(Cancel As Integer)
txtBorrowerCo = DLookup("CompanyNo", "LenderBorrower", "Name= Forms!frmLoanCreation!Borrower")
txtBorrowerID = DLookup("ID", "LenderBorrower", "Name= Forms!frmLoanCreation!Borrower")
txtBorrowerLocation = DLookup("Location", "LenderBorrower", "Name= Forms!frmLoanCreation!Borrower")
txtBorrowerSignee = DLookup("Signee", "LenderBorrower", "Name= Forms!frmLoanCreation!Borrower") '**** 991020
txtBorrowerTitle = DLookup("SigneeTitle", "LenderBorrower", "Name= Forms!frmLoanCreation!Borrower") '**** 991020
Child14.Requery
End Sub

Also, could you please explain what Requery does?
In 'Child14.Requery', Child14 refers to a gird