Hi,
I have been creating a database in Access 2003, I have created a form that will show information about a company. On this I have created a Command Button that will a form of the customer details for the relevant company that is shown on the form. I have the code below which is from a wizard
What I would like to do now is create another command button that will open a datasheet view as before but just to show the top twenty customers by highest balance. The field for highest balance is simply named 'Balance'
Hopefully you can help.
Cheers
I have been creating a database in Access 2003, I have created a form that will show information about a company. On this I have created a Command Button that will a form of the customer details for the relevant company that is shown on the form. I have the code below which is from a wizard
Code:
Private Sub Disclosures_Click()
On Error GoTo Err_Disclosures_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Customer Details"
stLinkCriteria = "[FINANCIAL INST NAME]=" & "'" & Me![Financial Institution] & "'"
DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria
Exit_Disclosures_Click:
Exit Sub
Err_Disclosures_Click:
MsgBox Err.Description
Resume Exit_Disclosures_Click
End Sub
Hopefully you can help.
Cheers
Comment