troubleshooting Question

select records based on user input Access 2010

Avatar of JoeBarbone
JoeBarbone asked on
Microsoft Access
8 Comments1 Solution447 ViewsLast Modified:

I have a database with information in it regarding jobs that employees are performing. They frequently need to update their records as items on a particular job# are completed. What I would like to do is prompt the user for their EmployeeID and ONLY display those records in a form/popup/etc and then have them select one of their own records from the list that was just displayed, then bring up the full form for that selected record for updating/editing.

This should be possible, correct? There are currently two tables, employees and jobs, employees has EmployeeID and EmployeeName and the jobs table has all of the job information plus EmployeeID.

Any information would be greatly appreciated.

Thank you in advance!


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros