Code not working 1

[Moss100]

Hello I am trying to filter a subform from another subform using the on current event.

Forms![frm_Contractor_Job]![Subfrm_Contractor_Job_Detail].Form.Filter = "Inv_Pman_Prop_ID_WorkAt_Link =" & Me.Repair_Property_ID_Link And "Inv_Pman_Cont_ID_Link =" & Me.Repair_Contractor_ID_Link

I think everything is named correctly, should the above work or is the code not correct?

Thank you Mark

 

[Andrzejek]

Hint:

Dim strFilter As String

strFilter = "Inv_Pman_Prop_ID_WorkAt_Link =" & Me.Repair_Property_ID_Link [highlight #FCE94F]And[/highlight] "Inv_Pman_Cont_ID_Link =" & Me.Repair_Contractor_ID_Link 

Debug.Print strFilter

Forms![frm_Contractor_Job]![Subfrm_Contractor_Job_Detail].Form.Filter = strFilter

Are [tt]Inv_Pman_Prop_ID_WorkAt_Link[/tt] and [tt]Inv_Pman_Cont_ID_Link[/tt] fields numbers or text?

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[Moss100]

Yes they are both numbers

This is what I have, but getting an error

Dim strFilter As String

strFilter = "Inv_Pman_Prop_ID_WorkAt_Link =" & Me.Repair_Property_ID_Link And "Inv_Pman_Cont_ID_Link =" & Me.Repair_Contractor_ID_Link

Debug.Print strFilter

Forms![frm_Contractor_Job]![Subfrm_Contractor_Job_Detail].Form.Filter = strFilter
Forms![frm_Contractor_Job]![Subfrm_Contractor_Job_Detail].Form.FilterOn = True

 

[Andrzejek]

I would guess you have a Type mismatch error on line:[tt]
strFilter = "Inv_Pman_Pr...[/tt]
If so, that would be good to mention.

strFilter = "Inv_Pman_Prop_ID_WorkAt_Link = " & Me.Repair_Property_ID_Link[highlight #FCE94F] & " And[/highlight] Inv_Pman_Cont_ID_Link = " & Me.Repair_Contractor_ID_Link

Debug.Print strFilter

With Forms![frm_Contractor_Job]![Subfrm_Contractor_Job_Detail].Form
    .Filter = strFilter
    .FilterOn = True 
End With

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[Moss100]

Thank you very much - all working

 

[Darrylles]

'Code not working'.

Wonderful term to enable people searching for a 'filter another form' solution - to find this particular issue.

*sigh*

Come on Moss - THINK ABOUT IT! ;-)
How about "Can't filter form from another form"?

ATB,

Darrylle