How To Create Search Form With Two Criteria In Microsoft Access With VB Code

Rujukan : Search Criteria/Dynamic Search Form


Dynamic search form means user can choose/enter a value between 2 boxes or choose only 1 box and leave other box null/empty. (A flexible search form provides several boxes where a user can enter criteria. An efficient search form creates the criteria from only those boxes where the user enters a value.
- by allenbrowne)




Step by step

1. Create a blank form

2. Under property sheet for ur empty form, select tableClient(your table/query) as a Record Source. This table/query will be ur data for ur form.

3. Under design view, add Id,Corporate,Companay name, City, Level fields.(Example field)



4. Then insert 6 textbox or combo box to be ur search box.(Type, Name Contains, City, Level, Entered Date) and 2 button for filter and unfilter function.(Can be search button and show all button)


5.  Then put code below under the On Click Event Producure on the property sheet for filter/search button.



link rujukan : http://www.iaccessworld.com/create-search-form-using-vba-ms-access/
&  http://allenbrowne.com/ser-62.html