Frank Rocco
|
| Posted: 08/21/2001, 10:50 AM |
|
Hello,
When I first display a grid, I want to show records that are not closed.
I want the user to be able to show closed records when they select the
status from a drop list in the search form. I cannot figure out how this is
done.
status_id = 3 when a record is closed.
Thanks for the help.
Frank
|
|
|
 |
CodeCharge
|
| Posted: 08/21/2001, 12:01 PM |
|
You can manipulate sSQL variable and change your SQL query within Form Open
Event. However it may get complex, depending on your query.
I recommend a more simple method:
Assming that you want this for the "Default" page, in Page Properties, Open
Event like this one:
If GetParam("priority_id") & GetParam("status_id") = "" then
response.redirect("Default.asp?notstatus_id=3")
then in Form Input, specify the field "status_id", variable "notstatus_id",
and the operator "<>".
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9lu71l$q01$1@news.codecharge.com...
> Hello,
>
> When I first display a grid, I want to show records that are not closed.
> I want the user to be able to show closed records when they select the
> status from a drop list in the search form. I cannot figure out how this
is
> done.
>
> status_id = 3 when a record is closed.
>
> Thanks for the help.
> Frank
>
>
|
|
|
|
Frank Rocco
|
| Posted: 08/22/2001, 6:17 AM |
|
I tried your suggestion, but the form is taking forever to load.
I get:
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/hd/Common.asp, line 25
Thanks
Frank
|
|
|
|
|
