Filter Criteria in Forms

[pgar]

Hi,
I am using Access 2003.
I have created a Entry form with a sub form displaying the description for the Code.
For example I have to make the entry for Employee data

***********************************
Employee Name
DepartmentCode Description
Region Code Description
***********************************

In the above Emp name, Dept Code and Region Code is from Main Emp Table and Description from the Master Tables.
I have used sub forms to display the descriptions

Now if I have to create a filter on Department to show all the employee Department. Is it possible if enter Description instead of the Code and it display all the employees in that department.

Thanks

 

[dhookom]

Use a combo box based on your "Master Tables" to allow users to select the code while actually seeing the description.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[pgar]

Can u Please explain in detail.

 

[dhookom]

First, describe your forms a little better. What is in your subform and why?
What is the following describing (form, table, query, ?):
***********************************
Employee Name
DepartmentCode Description
Region Code Description
***********************************

How do you want to create a filter?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]