Query Field with Multiple Selection Combo Box (1 Viewer)

[JithuAccess]

Hello Guys,

I have a multiple selection Combo Box in my Table:

These are the data in my Table:

I have created a query to Display only those Records where Countries are Canada and USA. This is my Query

And the Query Returns Nothing.

Could you please let me know how to solve this?

Thanks

 

[JithuAccess]

When I gave in the Query Criteria as:

I am getting the Query Result like:

But I just need

Thanks

 

[Pat Hartman]

That is correct based on your criteria. That's what happens when you use this abomination feature. It is best to use the old tried and true 1-m relationship and a subform rather than a multi-select list box. That way you can create a query that only returns the records you want.

PS, how can you have one postal code but multiple countries?

 

[JithuAccess]

That is correct based on your criteria. That's what happens when you use this abomination feature. It is best to use the old tried and true 1-m relationship and a subform rather than a multi-select list box. That way you can create a query that only returns the records you want.

PS, how can you have one postal code but multiple countries?

Many thanks for your reply. Could you kindly let me know how to use a subform instead of using a multi select combo box? Sorry I have no idea how to use this.

Currently I am using a very unprofessional method. I have added another field in the main Table next to countries "strCountries For Query" and then copy and paste whatever the data in the field Countries. And I have add a bounded Text Box (linked with strCountries For Query). For a new Entry, I put this VBA Code in the AfterUpdate Event of "StrCountries"

Dim strText As String
strText = Me.strCountries.Text

Me.strCountries_for_Query = strText

PS, how can you have one postal code but multiple countries?

This is a Sample Table I just put some random values. Please ignore this part.

Thanks a lot for your Help

 

[Pat Hartman]

Here's an example of a main form with a subform. This example is actually more sophisticated than what you need since the example shows a mainform with two related subforms. The first subform is members and the second is dependents. When you click on a row in the members subform, the dependents subform is synced to show only that members dependents.

mainform/subform examples are everywhere. They are used whenever you have a 1-m relationship. There is no trick here the master/child links on the first subform control are all that Access needs to sync the subform. The example was designed to show how to have a second dependent subform.

 

[JithuAccess]

Here's an example of a main form with a subform. This example is actually more sophisticated than what you need since the example shows a mainform with two related subforms. The first subform is members and the second is dependents. When you click on a row in the members subform, the dependents subform is synced to show only that members dependents.

mainform/subform examples are everywhere. They are used whenever you have a 1-m relationship. There is no trick here the master/child links on the first subform control are all that Access needs to sync the subform. The example was designed to show how to have a second dependent subform.

Thanks a lot. Let me check this