Try this sort of logic Dan, techtable1 TEXT = .techtable1 techwhere TEXT = .techwhere
Put these above the definitions that are failing. Play with . and & in your declarations. I have never, personally, used an ampersand variable in a form or report so I have no idea whether or not they are permitted. Dan Champion <[EMAIL PROTECTED]> wrote: >Hi all, >I have a program that sets 90 variables that I use in a form: > >Set V Tech10 = .techview FROM &techtable1 + >WHERE &techwhere AND serdat = .vardate1 AND cellno = "a0" > >I decided for speed that it would be better to create the variable in a >form rather than in the command file. >I tried to ADD/EDit variable: > >Tech10 = .techview FROM &techtable1 WHERE &techwhere AND serdat = >.vardate1 AND cellno = "a0" >And I get the error that the table &Techwhere doesn't exist. I use a >variable to describe which table, so that I can change the table on the fly. >Any work-arounds come to mind? >I need to be able to use either of two tables for that (and all other 89 >variables) >Thanks for your help >Dan > > >Dan Champion >www.championsolutions.net > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
