Hello everyone,
I was wondering if anyone can help. I have a filter code. It works almost exactly like I want it to, however, when activated I would like the user to have a list of choices to select from. Ideally this list would derive from the field to be filtered. Is there a way to do this? The code in place now is below:
Private Sub Command130_Click()
Dim LinkFilter As String
Dim FormName As String
LinkFilter = ""
If Not (IsNull(Me!Branch)) Then
LinkFilter = "[Choose Branch] = " & Me!Branch
End If
FormName = "Vendor Billing Entry Form"
DoCmd.OpenForm FormName, acNormal, , LinkFilter
End Sub
The user clicks the command button and types there choice and it filters perfectly, but I want to incoporate a list that needs to be selected from instead.
Thanks,
Nino
I was wondering if anyone can help. I have a filter code. It works almost exactly like I want it to, however, when activated I would like the user to have a list of choices to select from. Ideally this list would derive from the field to be filtered. Is there a way to do this? The code in place now is below:
Private Sub Command130_Click()
Dim LinkFilter As String
Dim FormName As String
LinkFilter = ""
If Not (IsNull(Me!Branch)) Then
LinkFilter = "[Choose Branch] = " & Me!Branch
End If
FormName = "Vendor Billing Entry Form"
DoCmd.OpenForm FormName, acNormal, , LinkFilter
End Sub
The user clicks the command button and types there choice and it filters perfectly, but I want to incoporate a list that needs to be selected from instead.
Thanks,
Nino
