Hi everyone, I'm trying to get a pop-up menu to work in a form using this syntax in the "where clause" box:
WHERE Name_Type IN (.vLookUp) ORDER BY Full_Name The value of vLookUp is defined as text and has a value of: "(A,B,C)" - the bit between the double quotes. I've tried a number of variations such as "&vLookUp" both with and without the brackets. I've also tried putting the IN in the variable: "IN (A,B,C)" and removing it from the where clause. Nothing I've tried seems to work. Is there some limitation on variables in the where clause here? R:Base gives me various error messages depending on the syntax but the real problem seems to be that it can't evaluate the variable. Thanks in advance for any help or suggestions, Regards, Alastair. ---------------------------------- A D B Burr, St. Albans, UK. ---------------------------------- [EMAIL PROTECTED] ---------------------------------- ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
