having buttons find a certain record based on first letter 2

[alblunkproex]

Scenario:

I have a continuous form with a vendor list... alphabetized by the vendor name.. I want to create 5 buttons that put the list at the first letter in the button... so if the button L-P it would go to the first record taht starts with L.

Any ideas?

 

[Remou]

Have a look at the Northwind sample database phone book form.

 

[alblunkproex]

i kinda get it, but how did they set the filter... VB doesnt like my quotation marks.

 

[Remou]

What did you put as the filter?

 

[alblunkproex]

[Vendor's Name] Like "A*" or "B*" or "C*....."E*

 

[Remou]

Either double these ", or one of these ':

"[Vendor's Name] Like 'A*' or 'B*' or 'C*'.....'E*'"

"[Vendor's Name] Like ""A*"" or ""B*"" or ""C*"".....""E*"""

Or

"[Vendor's Name] Like ""[A-E]*"""

 

[alblunkproex]

alright well it liked that but its not doing anything with this code.

Private Sub A_E_Click()
Me.Form.Filter = "[Vendor's Name] Like ""A*"" or ""B*"" or ""C*"" or ""D*"" or ""E*"""
Me.Requery
End Sub

 

[PHV]

Me.Form.Filter = "[Vendor's Name] Like '[A-E]*'"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Remou]

Skip the requery and add:

Me.FilterOn=True

 

[alblunkproex]

bitchin, thanks guys.