How to lookup entries in table using ID

[templeowls]

Basically I have a table full over various incidents with an employee ID attached to each incident. Is there a way to have a separate section where you can type in the an employee ID and it will populate all the incidents (rows in the table) that have this corresponding employee ID? Right now I have to manipulate the table or do ctrl+f to find all the times an employee has been in an incident. Just looking for a cleaner way.



I know I can export to excel and do a vlookup function to achieve the same thing, but I like to keep everything in Access (if possible)

[Micron]

what type of field is the ID field. Not an autonumber I hope. Sounds like you are working directly in tables, which you shouldn't. Don't know what a "section" is either, or what it applies to. An area on a form?
You use query criteria to filter lists, which may or may not come from a form control. Point is, that's where it should be coming from - not from table filtering.

[June7]

You can build a query with filter criteria. This is basic Access functionality.

More than one way to acquire user input for criteria.

1. intrinsic search/filter tools on ribbon and right click shortcut menu

2. dynamic parameterized query (I never use these)

3. code (macro or VBA) behind form, review http://allenbrowne.com/ser-62.html

[templeowls]

Yea I am already doing this. I was just looking to try and develop a query where you can type in the employee ID and it will show the incidents only associated with this ID. And maybe press a "refresh" button and all that data goes away and you can look at another ID.

I'm aware this is probably too specific of a request. I'm kinda new to Access so please don't yell at me haha

[June7]

If you want to work directly with query, use options 1 or 2.

Option 2 will prompt for user input when the query opens.

[templeowls]

Sweet. I appreciate the help!