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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top