Try this (Keep Expression order)
vDblDot text = ".vcolumn"
vNew = &vDblDot from table1 where columna = valuea
Ben Johnasen
www.pcforge.com
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Jim Miller
Sent: Thursday, August 02, 2001 1:36 PM
To: [EMAIL PROTECTED]
Subject: RE: Form Lookup on column name stored in a var
Here is an example.
vNew = .vcolumn from table1 where columna = valuea
When I use the & I get the error that i cannot start with a binary
expression.
Thanks for the help.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of david blocker
Sent: Thursday, August 02, 2001 2:27 PM
To: [EMAIL PROTECTED]
Subject: Re: Form Lookup on column name stored in a var
Jim
It should work if you do it like this:
reportvar1 = columnA in table1 WHERE linkcol = linkcol
where linkcol is the linking column name.
Now for the second expression, based on looking up columnA in a second table
using the variable:
reportvar2 = columnB in table2 WHERE columnA = .reportvar1
This should work. If this is what you're doing, what error message do you
get?
David Blocker
----- Original Message -----
From: "Jim Miller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 02, 2001 2:52 PM
Subject: Form Lookup on column name stored in a var
> I capture a columnname in a variable on a form and then I want to do a
> lookup on that column name. When I use a .var for the column name The
Latest
> and Greatest doesn't like it. Does anyone have any help.
>
> Thanks
>
>
