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
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