Proper Filter Syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The following code is working properly for text fields.

Private Sub cboPTCBL_AfterUpdate()
Me.Filter = " [PTC_BL]= '" & Me.cboPTCBL & "'"
Me.FilterOn = True
Me.cmdTurnFilterOff.Visible = True
End Sub

How does the syntax change if I want to run this filer on number field?

TIA
 
cvegas said:
The following code is working properly for text fields.

Private Sub cboPTCBL_AfterUpdate()
Me.Filter = " [PTC_BL]= ' " & Me.cboPTCBL & " ' "
Me.FilterOn = True
Me.cmdTurnFilterOff.Visible = True
End Sub

How does the syntax change if I want to run this filer on number field?
Click to expand...

Lose the single quotes.
 
You must log in or register to reply here.

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

Similar Threads

Filter syntax problems 2
Runtime error 2001 2
Creating a filter using VBA 5
Option group to filter a form 5
Filtered field goes blank 2
Form filter coding 4
Filtering and Removing Filter based on a combo box 4
filtering check boxes 3

Back
Top