Create a filter form maching with second form

[tihmir]

Hi, all. I need some help, please,
I’m working with two forms
Form_1 – “Filter”
Form_2 – “Objects”

In the Form_1 – “Filter” I have 3 comboboxes:
1-Municipalities
2-Cities
3-Тypes of objects
So, I want to open second form (Form_2 – “Objects”) with command button.
So, I want to choose in 1^st combobox Municipalities, then in 2^nd combobox to choose Cities and then in 3^rd to choose Тypes of objects.
When I choose Тypes of objects on pressing command button I want to open Form_2 – “Objects” which includes field „Тypes of objects“ but only Тypes of objects in the selected sity in the 2^nd combobox.

[pbaldy]

You can add a second field to this with AND between them:

http://www.baldyweb.com/wherecondition.htm

[tihmir]

When I choose an City in the combobox "Cities", then choose an object type in the combobox "TypeOfObject" on pressing comand button I want to load Form2 but load only these type of objects in selected sity (combobox "Cities").
This is my base......
Database4.zip

[pbaldy]

I won't be at a computer for a bit. Did you try to adapt that link?

[tihmir]

I won't be at a computer for a bit. Did you try to adapt that link?

Тhanks for the tips. I tried but still does not get. The probles is that I want to create two criterias:
1st - In the second form (Form_2) I want to load only Тypes of objects selected in 3rd combobox "TypeOfObject" on Form_1 and....
2nd - These TypeOfObjects must be only in the Cities selected in 2st combobox "Cities" on Form_1
Please, someone help me!!!

[pbaldy]

What exactly did you try that didn't work? This is air code:

DoCmd.OpenForm "form2", , , "CtiyID = " & Me.cbo_Cities & " AND ObjectID = " & Me.cbo_TypeOfObjects

[tihmir]

pbaldy Did you see my possted database?

[pbaldy]

Yes, it had no attempt to do this in it, unless I'm blind.

[tihmir]

Yes, it had no attempt to do this in it, unless I'm blind.

can you do it (VBA code) to my database and sand me back, please?

[tihmir]

I have cross posted my post because I can not do it.
https://www.access-programmers.co.uk/forums/showthread.php?p=1600161#post1600161