How to make Search forms

[Spark]

I am looking onto creating a database which is basically a search form for my company. I have 3 major questions and would be glad if someone could help since I am not at all familiar with access. I have managed to make the tables and a form to view all the clients and their data but my problem is with the search part of it:
- First I don’t know how to make a search-form, so should I make a query form or should I use a blank form to create it. Also I tried making the search on the form directly, which was obviously unsuccessful, since I don’t know if I should try using the SQL, macro or the code builder.
- Second, I know how to do the single search on queries but my problem is with multiple searches from the same field. I want to run a search based on the location of my client. So I have this column which has name of different countries, and usually 1 client can have more than 1 country listed, if they have subsidiaries. I want to create a search engine where I am able to select in any country/countries and any client in the database that are based in those countries to appear. So the condition is: Search for ‘client location’ in the ‘Client information’ table, where the location is ‘xyz’ or ‘abc’ or ‘def’ or…
- Third how do I make a form appear the first thing as soon as I open my access, like an opening page?

Thanks

[alansidman]

Look at this for a starter:

http://www.datapigtechnologies.com/f...earchform.html

Then this:

http://www.datapigtechnologies.com/f...ashscreen.html

Alan

[cap.zadi]

hey there, thanks for those links and working fantastic. would u help me to know that if the same procedure can apply to the combobox to select the names from combo box?

please advise.

thanks

zee

[alansidman]

Convert the text box to a combo box and use the same set up in your query.

Alan

[Spark]

HEy..
Thanks for the videos...the second one worked great for me...as for the main search form..well I am unable to make the 'Indexed' as duplicates OK since as i mentioned before the location field has multiple values...when i run the search macro the result it keeps giving me is my first client with that location and the other search criteria does not work at all..i guess it is because I am unable to change the format of the Indexed. Could you please help me out with that.

Thanks In Advance

[alansidman]

Suggest you try using the IN predicate in your query. In the criteria, type
In ("abc", "def") to find either abc or def.

Alan

[Spark]

So I am using the 'Area' and 'sector' as the search criteria, for the Area lets say I want to search for clients who are in 'N America' and 'GCC' and for the sector i want to search for 'energy' and 'agriculture', how should I do that. Like having multiple search at the same time from the same field with two criterias? So basically I want to perform multiple seach from two different fields.
So previously in my query the Sector had this criteria like the one the video showed: Like [Forms]![Search Form Display].[qsector1] & "*" and Like [Forms]![Search Form Display].[qarea1] & "*", How do I place the In command with this? Also then in the form I will have to do something such where I can enter two criterias in one field such as 'N America' and 'GCC'?
Thanks

[alansidman]

I have not done this, but thinking out loud I would:
1. Change combo boxes to a list boxes with your criteria options
2. Change your criteria on your query to IN(Forms![Search Form Display].qsector1) and to IN(Forms![Search Form Display].area1) for each of the fields.

This is untested but does seem logical to me. Let me know how and if it works for you.