Button to find specific data from a form

[hollyoak05]

I have created an access database which contains data about the calls employees have handled,i have 20 employees each have there own ID,in a form how do i find a specific value,for example to show just the calls handled by employee ID 1

[CreganTur]

You could use VBA to apply a filter to the forum, so that the filter only shows records where ID = 1.

Check Access help- it's god good resources on how to do this via VBA.

[orange]

You could use VBA to apply a filter to the forum, so that the filter only shows records where ID = 1.

Check Access help- it's god good resources on how to do this via VBA.


Here is a link that may help. There are some good examples for various topics.
http://www.fontstuff.com/siteindex.htm#access

[OBP]

hollyoak, ideally your database should have 2 tables, one for Employees and one for the calls, linked via the EmployeeID.
You should have a mainform where you can select an employee from a Combo Box set to Find a Record on my form. The calls for each employee should then be shown on a "Calls" Subform linked to the Mainform (Master/Child Links) using the EmployeeID.
Then each time you select an Employee it will show their calls in the subform.