filter a listbox

[david]

Hi,
i have made a form where i have 4 combolistbox (named: BOX1, BOX2, BOX3,
BOX4) and a listbox (Named: LIST1, it is based on a table).
i want to filter the data in the listbox by selecting some filter criteria
in one of the 4 combolistboxes.

i have tried to find out what to do, but i can't make anything of the
solutions to work.

I hope someone can help me with my problem.

 

[Maurice]

David,

Why not base your listbox on a query. Within the query you can reference the
comboboxes. In the after update of the combobox you can place a
me.listbox.requery which will requery the source of the listbox.

So in the query place the following in the criteria field of the combo (id
field): forms!formname!box1

In the after update of the box1 place: me.list1.requery

Ofcourse you must place the wildcards in the query if the user wants to see
all.

hth

 

[david]

i want the listbox to show all post in the form, also after i have activate
an filter criteria. is it posible without using a subform?

"Maurice" skrev:

 

[david]

"Maurice" skrev:

David,

Why not base your listbox on a query. Within the query you can reference the
comboboxes. In the after update of the combobox you can place a
me.listbox.requery which will requery the source of the listbox.

So in the query place the following in the criteria field of the combo (id
field): forms!formname!box1

In the after update of the box1 place: me.list1.requery

Ofcourse you must place the wildcards in the query if the user wants to see
all.

hth

 

[david]

it should be somthing like this
http://www.access-programmers.co.uk/forums/showthread.php?t=142422
but only with one form
and not with the selections of field and "<>"or"="

"david" skrev: