criteria problem

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I'm using the following in criteria:

IIf([Forms]![frmForm].[cboTerritory]="All" Or IsNull
([Forms]![frmForm].[cboTerritory]),[TerrID],[Forms]!
[frmForm].[cboTerritory])

It's working good except when cboTerritory is disabled or
empty the query returns nothing. (But, it is supposed to
return all records in this case).

To make the cboTerritory disabled I'm using
Me.cboTerritory.Enabled = False
Me.cboTerritory.Requery
Me.cboTerritory = Null

Could anybody advise what it's wrong there?

Thanks
 
Back
Top