Re: Form Lookup on column name stored in a var

[david blocker]

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