King Kreglo
Registered User.
- Local time
- Today, 08:42
- Joined
- Aug 31, 2013
- Messages
- 32
Firstly, sorry for all the questions today, the help is appreciated though
I have a form that filter records off of combo, I want the user to run reports based off of the filter selected in the combo box.
Here's the code I've been toying around with:
I ripped it off of another thread on here but my needs are slightly different so I couldn't quite get it to do what I wanted, any ideas?
I have a form that filter records off of combo, I want the user to run reports based off of the filter selected in the combo box.
Here's the code I've been toying around with:
Code:
Private Sub ReQuote_Click()
Dim strCustomer As String
Dim Filter As String
If IsNull(Me![cboFilter]) Then Exit Sub
strCustomer = Nz(Me.cboFilter, "*")
Filter = "strCustomer = "" & strCustomer"" "
'Filter ="strCustomer = "" & Me.cboFilter""
DoCmd.OpenReport "tblOrder Details", acViewReport, Filter
End Sub
I ripped it off of another thread on here but my needs are slightly different so I couldn't quite get it to do what I wanted, any ideas?