Victor - The missing global variable could also be used in a WHERE clause in a pop-up.
Sami ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Victor Timmons Sent: Friday, February 18, 2005 12:29 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: -Error- 2161 Thank you David. This form has no list box, or combo boxes. This is also a 6.5++ for windows database. I will look at everthing else on the form. On 18 Feb 2005 at 12:27, David M. Blocker wrote: > Victor > > There could be an error in one of the controls, such as a list box or combo > box with a WHERE clause. Do all the controls on the form work correctly? > For starters, look for one that ISN'T and then look at its properties > > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 > ----- Original Message ----- > From: "Victor Timmons" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Friday, February 18, 2005 12:51 PM > Subject: [RBASE-L] - -Error- 2161 > > > > I get an error that reads > > > > -ERROR- Unrecongnized Global Variable in Expression. [2161] > > > > All I have to do to get this error is to open the form and save it, no > > changes. > > > > EDIT USING WorkOrderPick4 + > > WHERE EstimateNumber IN + > > (SELECT EstimateNumber FROM EstimateHeader WHERE OrderShipped <> 'S') + > > ORDER BY BoFlag ,ShippingDate,EstimateNumber,ShippingID NOHEADER > > > > IF I run the same form from the R> and use the same code it runs just > > fine. If I go back to backup of the form and run it from the RMD file it > > runs just fine. If I open the form in design mode and save with no changes > > being done to it. I get the error. > > > > I have tried to reload the database it reload just fine with no errors. I > > see no errors in the Expression List for the form. Not sure what else I > > should be looking for. > > > > Thanks for the Help > > > > > > > > > > > > Victor Timmons > > Tiz's Door Sales, Inc > > 425-258-2391 > > > > --- RBASE-L > > ================================================ > > TO POST A MESSAGE TO ALL MEMBERS: > > Send a plain text email to [email protected] > > > > (Don't use any of these words as your Subject: > > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [email protected] > > In the message SUBJECT, put just one word: INTRO > > ================================================ > > TO UNSUBSCRIBE: > > Send a plain text email to [email protected] > > In the message SUBJECT, put just one word: UNSUBSCRIBE > > ================================================ > > TO SEARCH ARCHIVES: > > Send a plain text email to [email protected] > > In the message SUBJECT, put just one word: SEARCH-n > > (where n is the number of days). In the message body, > > place any > > text to search for. > > ================================================ > > > > > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
