I need to set a filter on a query so I can run a report from a joined query. I want to do this from a form, since I already have selected a record with the [acct nbr] I want. I just can't figure out how to do this but I thought it would be simple. I need to run a report that is filtered from the joined query so I can run a text stream to put into Outlook. I have the Outlook section done. I just need the filtered text stream.
If I can't filter the query from the combo box VBA, then filtering from the Forms![acct nbr] is fine. Or, filtering the report by [acct nbr] is fine as well.
The Combo box VBA is below.
Private Sub Combo34_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[ID] = " & Str(Nz(Me![Combo34], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark