Somebody elses query

[Ringers]

Somebody else wrote the attached query, it filters my form by the first combo box(branch_name). I want it to filter the form by both combo boxes cbobranch_name and cbobranch_city.

It would be good if somebody could help. Cause this is the last thing to do on my companys database, then it's finished.

 

[WayneRyan]

Ringers,

Just add the column in your database (branch) to the query.
I think it does city, just add branch. Use the same syntax
as in the other name.

Then just add a Me.Requery to the AfterUpdate of your
other combo.

Wayne

 

[Ringers]

Wayne,

I changed the query to include branch_name and branch_city, but the form only updates when you have from cboBranch_Name.uggh.

I have tried reversing the query order of branch_city and branch_name. When you put branch_name before branch_city it stops working completely.

I have a screen of what i have.

 

[Ringers]

I got it, finally. Thanks for you help wayne, i wouldn't have got it with you.