Help with Macro syntax

[P.Zerbie]

I'm a newbie to forums and only limited access experience ... albeit over 15 years.

I'm trying to adapt a Northwind toggle bar feature to my own application. Specifically, the macro for customer phone list using the applyfilter action with the 'Like' arguments for each letter of the alphabet.
For instance for the letter 'A' it has:
[CompanyName] Like "[AÀÁÂÃÄ]*"

What I am trying to do is an 'OR' argument so it looks for any company name starting with 'A' or starting with 'Dr A'. eg it will return Dr Adams as well as Astra pharmaceuticals.

So it should be someting like [CompanyName] Like "[AÀÁÂÃÄ]*" OR "Dr A*"

So far I know that each part of this works perfectly on its own but when the two are joined with the OR it returns every record in the dataset..ie all letters of the alphabet. So it must be a syntax issue but I don't know what.

I suspect a VB code could be the way to go but since this is for each letter of the alphabet and also an "all" option, it may get long winded so I'm just trying to adapt the Nortwind version.

Any help or guidance with this will be most warmly welcomed.

Cheers

 

[apr pillai]

Take a look at this link: Filter by character and sort.