G
Guest
Hi,
I'm trying (and failing) to make the available options on a list box control
conditional on what is entered into another control (which also happens to be
a list box). I've been trying to use the macro action ApplyFilter (and have
made queries that should restrict the options in the list box) but this seems
to want to filter the records rather than the options of the list box.
The options in the list box are taken from a separate table. The query used
for the filter then applies to this table, but the macro doesn't work as
planned.
In detail the macro is as follows it is liked to the OnClick property of the
control [distict]:
Conditon [district]=Kasungu Action Apply Filter: Health facilities in
Kasungu (this is a query that applies to the table 'All Health Facilities'
and has the 'show' button ticked for the criteria Dist="K")
Conditon [district]=Lilongwe Action Apply Filter: Health facilities in
Lilongwe (this is a query that applies to the table 'All Health Facilities'
and has the 'show' button ticked for the criteria Dist="L")
Conditon [district]=Salima Action Apply Filter: Health facilities in Salima
(this is a query that applies to the table 'All Health Facilities' and has
the 'show' button ticked for the criteria Dist="S")
Can you help me?
Tim
I'm trying (and failing) to make the available options on a list box control
conditional on what is entered into another control (which also happens to be
a list box). I've been trying to use the macro action ApplyFilter (and have
made queries that should restrict the options in the list box) but this seems
to want to filter the records rather than the options of the list box.
The options in the list box are taken from a separate table. The query used
for the filter then applies to this table, but the macro doesn't work as
planned.
In detail the macro is as follows it is liked to the OnClick property of the
control [distict]:
Conditon [district]=Kasungu Action Apply Filter: Health facilities in
Kasungu (this is a query that applies to the table 'All Health Facilities'
and has the 'show' button ticked for the criteria Dist="K")
Conditon [district]=Lilongwe Action Apply Filter: Health facilities in
Lilongwe (this is a query that applies to the table 'All Health Facilities'
and has the 'show' button ticked for the criteria Dist="L")
Conditon [district]=Salima Action Apply Filter: Health facilities in Salima
(this is a query that applies to the table 'All Health Facilities' and has
the 'show' button ticked for the criteria Dist="S")
Can you help me?
Tim