.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

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

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

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