.Filter 2 criteria

  • Thread starter Thread starter Chad Cameron
  • Start date Start date
C

Chad Cameron

Hi All,

is there a way to have 2 items in a .Filter criteria? This is what I have:
Me.Filter = "[CompanyID] = " & cbCompanyName
Me.FilterOn = True

But I want to filter on CompanyID & ContractorID

Is this possible?
Thanks
Chad

PS: Sorry if I posted this wrong. I already posted this into a deep thread
that might be dead. I am not sure of proper etiquette on reposting
 
Chad said:
is there a way to have 2 items in a .Filter criteria? This is what I have:
Me.Filter = "[CompanyID] = " & cbCompanyName
Me.FilterOn = True

But I want to filter on CompanyID & ContractorID
Click to expand...

The Filter is like the WHERE clause in a SELECT statement:

Me.Filter = "[CompanyID] = " & cbCompanyName & _
" And ContractorID = " & SomeNumber
 
Back
Top