Etxezarreta
Member
- Local time
- Today, 08:33
- Joined
- Apr 13, 2020
- Messages
- 175
Hello everyone,
In order to update one table (t_AffectationProjetA_Contacts), I populate a temporary table (t_ConsultationContactProjet_temp_modiftableprincipale) with a VBA SQL query in the form f_ConsultationGestionContacts _Projets: I select different criteria in 5 list zones-> populate the subform linked to the temporary table (t_ConsultationContactProjet_temp_modiftableprincipale) -> the user can modify some data in the subform -> he validates-> updates the final table (t_AffectationProjetA_Contacts): this works just fine.
I use a temporary table because the final one is very "condensate": only primary key and foreign keys, nothing explicit to be dealt with directly in a form.
I would like to enable the user to find a contact by anotherway, from the same form: he writes some letters in a textbox (txt_SaisieNomPourRecherche) and thanks to the "change" event-> a query runs and filters the subform, with a WHERE LIKE value of the text box: I prefer a filtration rather than a creation of a new recordset.
I have been trying this out for hours: no way.. (you will find the code in f_ConsultationGestionContacts _Projets-> Sub txt_SaisieNomPourRecherche_change)
Could you please help me?
Many thanks.
Etxe.
In order to update one table (t_AffectationProjetA_Contacts), I populate a temporary table (t_ConsultationContactProjet_temp_modiftableprincipale) with a VBA SQL query in the form f_ConsultationGestionContacts _Projets: I select different criteria in 5 list zones-> populate the subform linked to the temporary table (t_ConsultationContactProjet_temp_modiftableprincipale) -> the user can modify some data in the subform -> he validates-> updates the final table (t_AffectationProjetA_Contacts): this works just fine.
I use a temporary table because the final one is very "condensate": only primary key and foreign keys, nothing explicit to be dealt with directly in a form.
I would like to enable the user to find a contact by anotherway, from the same form: he writes some letters in a textbox (txt_SaisieNomPourRecherche) and thanks to the "change" event-> a query runs and filters the subform, with a WHERE LIKE value of the text box: I prefer a filtration rather than a creation of a new recordset.
I have been trying this out for hours: no way.. (you will find the code in f_ConsultationGestionContacts _Projets-> Sub txt_SaisieNomPourRecherche_change)
Could you please help me?
Many thanks.
Etxe.