Filter Subform with Listbox

Question

1. Main form is unbound
2. Listbox (List1) row source - SELECT Code, Customer, Description FROM Jobs;

    bound column - Code        
   

3. Subform1 - record source - Jobs_Invoices (query) - datasheet view

the Jobs_Invoices query has 1-M relationship where Jobs has the primary key (Code) and Invoices has the foreign key (Inv_Det_Code).

The code below does not filter the subform when the list is clicked. Is the syntax incorrect?

Private Sub List1_Click()

Me.Filter = "([Me!Subform1.Form!Inv_Det_Code])" = " & Me.List1.Value"

Me.FilterOn = True

End Sub

Answer 1

Private Sub List1_Click()

Me.Subform1.Form.Filter = "Inv_Det_Code = " & Me.List1

Me.Subform1.Form.FilterOn = True

End Sub

Answer 2

No luck. Do I bound the main form, subform, and list box all to the same Query? then Master link the list field and child link the subform field?

Also, my listbox is showing multiple records with the same job number - where I only wanted unique job #s for the list box to click and display all invoices in the subform from that job.

Answer 3

The listbox, which has a value of JobCode.

Answer 4

What would I use as the LinkMasterField? Does the Listbox need the same control source as the subform?

Answer 5

Would it be easier to set the subform control's LinkMasterFields and LinkChildFields?