Access form filter

[Droups]

I would really need help figuring out how to set a filter on a combobox.

Let me explain my situation:

I have an Access database to manage services provided by a firm.

I’m using 5 tables to manage these services — you can find them attached.



In my form, to insert a new service, I use a combobox called cmbPrestazioni.

Its rowsource is:

SELECT Anagrafica_Prestazioni.ID_Prestazione, Tipo_Macro & ' - ' & Desc_Prestazione AS VoceCompleta
FROM Anagrafica_Prestazioni
ORDER BY Anagrafica_Prestazioni.Tipo_Macro, Anagrafica_Prestazioni.ID_Prestazione;

With 2 columns: 0cm;7cm.

What I would like to achieve is allowing the user to filter the possible results while typing in the combobox.

For example: if the user types “Ass”, I would like the combobox to show all records where either Desc_Prestazione or VoceCompleta contains the consecutive letters “Ass” (case insensitive).

If the user deletes a letter, the filter should update accordingly.
If the combobox is empty, then the rowsource should return to the original unfiltered query.

Can someone help me?

[mike60smart]

Can you upload your database?

[Welshgasman]

Likely need to use the change event and only apply filter if there is a value in the combo.

[jojowhite]

Here test this, if this is what you need.
Attachment 52956

[Droups]

Yes, this is it.

https://limewire.com/d/1pbiE#FVH9T4jwF1

[Welshgasman]

I entered over 23K records using a combo for the data.
here is one for the crew

SELECT Crew.ID, Trim([surname] & " " & [initials]) AS Name, Crew.CrewDept, Crew.Cabin
FROM Crew
ORDER BY Trim([surname] & " " & [initials]);

As I typed in the name, it automatically located the record(s) or ran the NotinList event.

[pbaldy]

Post 5 was moderated, I'm posting to trigger email notifications.

[mike60smart]

Hi

It is very difficult to understand your business process when most of your tables contain Autonumber fields using Text and Number Data Types.
Also there are no relationships set between any of your tables?

What is the database designed to do for you?