SQL Filter?

[dev82]

Hello Guys,

i have this access mdb and i would like to filter in the menü the "airline" and "kette" i have access 2002. if i click on "suchen" the code dosent's work. i can't find the problem.

Thanks
Dev82

[orange]

You don't indicate what you would like to happen -- just that it doesn't work -- doesn't help much.

I think you should watch the free video tutorial here
http://www.datapigtechnologies.com/f...combobox2.html
to see if selecting something in one list affects what can be selected in the second list.

You may also want to watch
http://www.datapigtechnologies.com/f...tboxtrick.html

[dev82]

Hello orange,

that's not my problem. i would like to filter the data via the subform from the main menü.

Dev82

[orange]

Please give an example of what you would like to happen.

I tried your mdb and don't know what you think is suppose to happen.

What do you think is being placed in the immediate window?
What does it represent?

[dev82]

in the form "menü" you can mark the "kette" and "airline" i would like to mark 2 or 3 of them and then filter the data, the subform has to show me the filtered data.