Subject | Passing parameters before posting a search |
---|---|
Author | Jeff Clement |
Post date | 2001-07-23T10:38:02Z |
Hi there,
I have a question which some of the more advanced IBO users
might be able to answer for me.
I have a form as a frontend to a report. The form has two edit
boxes for a from and to dates respectively which are used to set
the from and to date parameters in the query. I also have a search
grid for the user to enter in additional search criteria. The query is
on financial transactions in case you are wondering.
The dataset starts of in search mode. The user enters in the from
and to dates and any search criteria in the search grid. When they
hit the preview or print buttons I set the from and to date
parameters in my query and then post the search.
The problem is that I keep getting a response that no records were
found because the parameters don't seem to be updating before
posting the search. What am I doing wrong? Should I be going
about this task another way?
Any suggestions or ideas would really be appreciated. Thanks!
Jeff.
I have a question which some of the more advanced IBO users
might be able to answer for me.
I have a form as a frontend to a report. The form has two edit
boxes for a from and to dates respectively which are used to set
the from and to date parameters in the query. I also have a search
grid for the user to enter in additional search criteria. The query is
on financial transactions in case you are wondering.
The dataset starts of in search mode. The user enters in the from
and to dates and any search criteria in the search grid. When they
hit the preview or print buttons I set the from and to date
parameters in my query and then post the search.
The problem is that I keep getting a response that no records were
found because the parameters don't seem to be updating before
posting the search. What am I doing wrong? Should I be going
about this task another way?
Any suggestions or ideas would really be appreciated. Thanks!
Jeff.