StumblingDrunk
New member
- Local time
- Today, 06:15
- Joined
- Jul 28, 2009
- Messages
- 2
Hi
I am new to the forum, but it looks like you may be able to give me some much needed guidance
A summary of my issue:
I have a form with two combo boxes. The first is the Country and the second is the County/State. I want to create a query that will look at the first combo box (country) to populate a form, and then use the second combo box, if it has been filled in.
Not sure if this makes much sense but for example:
One person just wants all the results for England on the form, whilst another person may just want the results from Essex in England.
I have tried multiple thngs like IIf isnull etc, but I cannot get it quite right. It either populates everything for that country everytime, or only works if the country and county/state are populated.
I have had a look on multiple forums and posts, but have had no luck so far (although I am sure this is relatively straight forward).
Any help will be greatly appreciated
I am new to the forum, but it looks like you may be able to give me some much needed guidance
A summary of my issue:
I have a form with two combo boxes. The first is the Country and the second is the County/State. I want to create a query that will look at the first combo box (country) to populate a form, and then use the second combo box, if it has been filled in.
Not sure if this makes much sense but for example:
One person just wants all the results for England on the form, whilst another person may just want the results from Essex in England.
I have tried multiple thngs like IIf isnull etc, but I cannot get it quite right. It either populates everything for that country everytime, or only works if the country and county/state are populated.
I have had a look on multiple forums and posts, but have had no luck so far (although I am sure this is relatively straight forward).
Any help will be greatly appreciated