Selection Box (1 Viewer)

[Space Cowboy]

If I have a selection box with ten identifiers France, England, USA, Ireland etc

Can I configure it somehow to filter on that selection?

 

[arnelgp]

is the selection box a combobox? yes you can filter the Form.
add code to the AfterUpdate event of the combobox:

Private Sub TheCombobox_AfterUpdate()
    If Me.TheCombobox.ListIndex < 0 Then
        DoCmd.ShowAllRecords
    Else
        DoCmd.ApplyFilter , "FieldName = '" & Me.TheCombobox & "'"
    End If
End Sub

 

[Space Cowboy]

Thanks Arnelgp
In theory, can two or three "Conditions" be conjoined or will that have to go through Sub Forms?

 

[Mike Krailo]

What kind of selections are you talking about? Check boxes or combo box single selections?

 

[Mike Krailo]

If you have multiple combo boxes, then you would have to update or filter out the previous selections for each subsequent selection, but I would think it would be easier to use a multiselect list box that would build a filter string, then after you press a button, it would do the filtering.

 

[arnelgp]

it's hard to explain without any concrete example for you to study.
look at product form and see the code on the AfterUpdate event of the Country Listbox.

 

[MajP]

To configure a Listbox to be multiselect go to the "Other" tab and in the property "Multi Select" pick "Simple"

 

[Space Cowboy]

What kind of selections are you talking about? Check boxes or combo box single selections?

Hi Mike,

I have not made a form before, I dont know what the correct type of box will be, trying to find out the right way before I start. I have read a few articles on forms and watched some videos on Youtube but non seem to show this.

 

[gemma-the-husky]

You would be better having an identifier table with a numbered index.

So 1 = England, 2=France etc.

That way you test for the numeric value. If you want to change England to UK, Czech Republic to Czechia, you can do without affecting any code.

You may be able to add new countries as well depending how your app deals with the selection..

 

[Space Cowboy]

Hi Gemma the husky

can you please direct me to an article that explains what you mean?

 

[GPGeorge]

Hi Gemma the husky

can you please direct me to an article that explains what you mean?

This is often referred to as a Lookup table. It is a table in which you list all of the valid values for an entity, e.g. "Countries". That lookup table can grow as additional values are needed, simply by adding a record for the new value.

That table is the row source for a combo box or a list box.

 

[Gasman]

If I have a selection box with ten identifiers France, England, USA, Ireland etc

Can I configure it somehow to filter on that selection?

Configure what? Filter what?

 

[gemma-the-husky]

Create a table, called countries, with your various countries. Have a number column -autonumber would be a good idea.

In your customer Data, or sales data, or whatever you are trying to filter, add a column called Country code, as a number, (long integer). Set the field type as combo box, and the wizard will let you pick the country table and set it up for you.

When you add countrycode to a form, it will then automatically be shown as a working combo box. You can do all this manually, but using automation will let you see how it works anyway. Most of us probably do it manually as we prefer to make some of the choices ourselves.

The country will be stored as the numeric value, but will be displayed as the text value from the countries table corresponding to the selected number

 

[MajP]

I dont know what the correct type of box will be, trying to find out the right way before I start. I have read a few articles on forms and watched some videos on Youtube but non seem to show this.

@arnelgp provided a working demo, can you at least say if that is what you want? If not what would you like different?

 

[Space Cowboy]

@arnelgp provided a working demo, can you at least say if that is what you want? If not what would you like different?

That would do nicely!
It did not work correctly as my access would not run it due to dangerous executable code. but I managed one attempt at a filter and it worked.

 

[Gasman]

Waste of time giving you any examples then?

 

[MajP]

That would do nicely!
It did not work correctly as my access would not run it due to dangerous executable code. but I managed one attempt at a filter and it worked.

When you download a dB you need to right click and go to proprties. Select Unblock.

 

[Gasman]

I do not get that window? possibly because I am using Explorer Patcher on Win11?
What about Trust location?
I download all my db's to a temp folder and have trusted that.

 

[Mike Krailo]

Yes, I always move the downloaded files to a trusted folder as well.

 

[MajP]

Yes there are cases where the Web mark is not added or moved to trusted location.