Re: QUESTION: MENU - NOT LIKE

[Brian Goralczyk]

** Tyrone,

Instead try NOT ('Group List' LIKE "%" + " 1;" + "%" or 'Group List Like "1;" + "%")

What will cover if administrator is the first option or not.

HTH,

Brian

On 10/27/06, Tyrone Dee <[EMAIL PROTECTED]> wrote:

**

I have a Menu that shows all Users from the USER Form - no problem.

 

I would like to restrict all users who are Administrators from the pull down menu.  I tried:

 

NOT 'Group List' LIKE "%" + "1" + "%"

 

However, this is not working as there are other groups with "1" in the Group Number.

 

Any assistance would be greatly appreciated.

 

THANKS!

__20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___