How can I create a search button in access 2007

[Bbjean]

How can i create a search button in Microsoft Access 2007 with this corresponding information for the employee Details.

IDNO
Position Description
Unit Description
Cluster Description
Rank Description
Region Description
Date of Assumption
Year
Pin
Salary Grade
New Salary
Previous Salary
Appointment Status
Appointment Date
Last Promotion
Date Issued

I dont should I do I'v always do research but it ddint fit to my search buttton pls help me to do my task
thank you.

[zmbd]

Basic Steps:
You create a form.
You add the fields.
You add a command button.
The vba/macro (don't confuse the two. VBA is NOT macro in Access) behind the on_click event for the command button can handle this in a number of ways, two of which are:
1) by opening a query that uses these fields as parameters,
2) the code will take the values from your fields and build an SQL string that will then return your recordset that you can then display against either a second form, a subform, or within the form you have built.

For either method, the easiest way to get a template for your SQL is to open a new query in design mode against the table(s) you need, create the query using a simple set of parameters first. Once it works correctly for the simple set, then you can either modify it to use the values from the form (opt1) or you can capture the SQL (switch to SQL view) and then use that as the template to build your string from for the vba code.

Please keep in mind that Bytes is not a code nor homework service, please read the FAQ and posting guidelines; however, as you write your code, if you will post your work when you hit a snag we can assist you with specic issues.