.Filter 2 criteria

[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

 

[Hans Up]

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

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

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