I agree with the general points made by
@plog about your query structure.
I want to mention some other issues which are also massively contributing to your speed issues
1. Using subdatasheets in your tables significantly affects performance as these need to be loaded whenever tables or queries based on these are open. End users should never view tables or queries directly so you should remove all subdatasheets
2. As already stated ensure all fields used in joins and filters are indexed. This will make a major difference in terms of speed
3. Your form search is currently based on the On Change event which runs after each key press. Change this to the After Update event
4. Only search one field with each search box. If you want to allow users to search 4 fields, use 4 different search boxes. I recommend using a combo for each
5. Remove the leading wildcards as this stops the index being used. Only allow a trailing wildcard on each case. This will allow the use of indexes.
5. Subforms always load before the main form. You can speed up the main form loading by removing the subform row source on form load. Then set the row source to your modified ResultFinal query as part of the search box after update event
I've made some of the above changes in the attached database. I hope this helps.
Much more needs to be done but as I can't read / understand the language used, I'm unable to do any more