frm with 2 combo box's

I have a form (frmStamps) with two combo box's in the form header

1. CountryCombo
2. CityCombo (which is linked to the CountryCombo so I only see Cities in that Country)



My query has:
Country Criteria as: [Forms]![frmStamps]![CountryCombo]
City Criteria as: IIf([Forms]![frmStamps]![CityCombo]="", ([tblStamps].[City]) Like "*",[Forms]![frmStamps]![CityCombo])

I want it to show all the cities if the CityCombo is blank (no selection), but filter if there is a CityCombo selection.


is this something that would be better done in VBA or is there some other way? I tried to do the OR method but it didn't work

lot easier to give suitable solution with a workbook.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I just did it in VBA and applied it as filters.

the way it works with the code below is, if no boxes are checked, all options are shown but as soon as you check a box, only that option is shown... and if more than one box is checked all of those options are shown.

HTML Code: