At 05:25 PM 7/26/2005, Jan Johansen wrote:
Here's the WHERE clause from the WHERE Clause block in the DB-Edit .... WHERE EmpStatus = 'Y' AND EmpLevel NOT IN (0) ORDER BY EmpFirstName ASC TITLE 'Select Technician...' CAPTION 'Employee Name...' LINES 20 OPTION LIST_FONT_NAME Courier | LIST_FONT_SIZE 12 Once I removed everything from TITLE to the end the popup worked fine. I had removed from LINES to the end just to see if it would work at first but it didn't.
Jan, Where in the world did you see the support for additional options in the "WHERE clause" of Pop-up menus for DB/Variable Edit Controls? Are you dreaming or too much vacation? <g> The WHERE clause, in your case should only include the following: WHERE EmpStatus = 'Y' AND EmpLevel NOT IN (0) ORDER BY EmpFirstName ASC If you need to customize that Pop-up Menu, use the latest enhanced Pop-up Menu designer options as suggested in: Tip of the Day: Tip of the Day: Designing Custom Pop-up Menus (07/26/2005) Here's how (using the latest RBG75, Build: 7.5.12.30725 or higher): Form Designer|DB Edit|Variable Edit Properties|Pop-up Menus Notice the following additional options: . Show Lines (to separate multiple columns for a better look) . Title Font and Color . List Font and Color . Title Background Color . List Background Color That's all there is to it! Very Best R:egards, Razzak.
