Thanks, Mike, but that doesn't solve it. I get a "No rows exist or satisfy the specified clause" message but the choose works at the R:> as expected (with or without the extra quotes).
It is as if the form pop-up menu box can only accept column names or text and cannot evaluate a dotted or ampersand variable: WHERE Name_Type IN (A,B,C) ORDER BY Full_Name works but WHERE Name_Type IN (.vLookUp) ORDER BY Full_Name does not work - with whatever variations that I've tried for the variable. Albert, I can't figure out how to get your example into the where clause in the box on the form but thanks anyway. Again, I think that this particular box just cannot evaluate a variable... Dennis, your idea would work for me if I used an EEP to pop-up the choices but I would still be stuck getting the variable into the where clause box on the pop-up menu box for the field on the form. It looks as if I'll have to pop the menu up from the EEP which is easy enough but, in this case, means quite a big change to the form which I was trying to avoid. It's the change that probably breaks the camel's back and means I really ought to re-construct the form from first principles to consolidate various changes and I was just feeling put off by the thought of the work involved. Thanks, everyone, Regards, Alastair. ----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 7:31 PM Subject: Re: Forms: Pop-Up menu - Where clause variable > How about single quotes surrounding each of the IN LIST parts? > > ----- Original Message ----- > From: "Alastair Burr" <[EMAIL PROTECTED]> > To: "R:Base ListServer" <[EMAIL PROTECTED]> > Sent: Monday, July 01, 2002 12:08 PM > Subject: Forms: Pop-Up menu - Where clause variable > > > > 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/ > > > > ================================================ > 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/ ================================================ 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/
