Dante S.
|
Posted: 05/30/2001, 6:48 AM |
|
How do I reference the input fields defined in the form properties (Input
tab) in the Where entry field (which is on the SQL tab on the form
properties)?
|
|
|
CodeCharge
|
Posted: 05/30/2001, 2:57 PM |
|
You don't :)
The Input section is automatically converted and generated as the WHERE
clause.
However, if you need more complex WHERE and want to obtain the values of the
parameters passed to the form, you can manipulate the "sWhere" variable in
the "Open" Event in Form properties, and use GetParam function to obtain the
values of the paramaters.
For example, you you may create a Form Open event like this:
sWhere = " WHERE company_name=" & GetParam("comp") & " AND state_code=" &
GetParam("state")
"Dante S." <disandigan@loyolaplans.com> wrote in message
news:9f2to3$65c$1@mail.tankhill.com...
> How do I reference the input fields defined in the form properties (Input
> tab) in the Where entry field (which is on the SQL tab on the form
> properties)?
>
>
|
|
|
|