Filtering a Subform from an unbound combo box

[andy1968]

I am trying to filter a subform from an unbound combobox on the main form.


I have the following code in the after update event for the combo box:


Me.frmPublicCommentRecallList.Visible = True

Me.frmPublicCommentRecallList.Form.Filter = "[Job]= " & Me.Job
Me.frmPublicCommentRecallList.Form.FilterOn = True

The subform stays empty.


The database is attached.

 

[JHB]

The job is text, so:

Me.frmPublicCommentRecallList.Form.Filter = "[Job]= [B][COLOR=Red]'[/COLOR][/B]" & Me.Job[B][COLOR=red] & "'"[/COLOR][/B]