Filter Syntax Question

[NeroMaj]

I want to filter values on a forms based on the ID in a query and the ID in a table. I think this should work, but it does not.

Dim strFilter as string

strFilter = "tblEAD.ID = qryACEA.ID"

Forms_frmEngineerHome.Filter = strFilter
Forms_frmEngineerHome.FilterOn = True

Do I need to do a DLookup() Function for the qryACEA.ID part, or is there another syntax to doing this.

I have predefined queries with ID column that is pulled from the primary key of the tblEAD.

 

[MarkK]

Something like this seems more like it ...

Dim strFilter as string
strFilter = "ID = " & DLookup("ID", "qryACEA", SomeCriteria)
Forms!frmEngineerHome.Filter = strFilter
Forms!frmEngineerHome.FilterOn = True