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. > ================================================ > >
