M
Mauricio Silva
I have a form where I put a serie of controls as key to filter my data: a
CheckBox, a Textbox and 2 comboboxes (1 of them I chage dynamically). Since I
have a complex form, I've created a button "Process Filter" where the access
reads the content of these objects and run the filter on several diferent SQL
commands.
The button call a function like this
=ProcessFilter([GroupByFunction],[TextFiscalYear],[ComboPlatform],[ComboBusiness])
the ProcessFilter does:
- verify their content
- turn off the button
- show a label "Processing..."
- call the filter subrotine
- hide the label "Processing..."
- turn on the button
The thing is, it goes thru the validation, i calls the filter subrotine and
them error, because my objects don't have the data anymore, they are all null
(but they still show their data on screen).
What can I do? The filter objects are in the detail section.
Thanks
Mauricio Silva
CheckBox, a Textbox and 2 comboboxes (1 of them I chage dynamically). Since I
have a complex form, I've created a button "Process Filter" where the access
reads the content of these objects and run the filter on several diferent SQL
commands.
The button call a function like this
=ProcessFilter([GroupByFunction],[TextFiscalYear],[ComboPlatform],[ComboBusiness])
the ProcessFilter does:
- verify their content
- turn off the button
- show a label "Processing..."
- call the filter subrotine
- hide the label "Processing..."
- turn on the button
The thing is, it goes thru the validation, i calls the filter subrotine and
them error, because my objects don't have the data anymore, they are all null
(but they still show their data on screen).
What can I do? The filter objects are in the detail section.
Thanks
Mauricio Silva