I am a new access user and trying to create a simple query which will take a user selected job title from a form and then display a query that shows that selection + the corresponding job code.
My form is titled picktitle and the user selects from a list of job titles from a list- the field where they make their selection is called jobtitle. The list the user selects from is actually the same data used in the query. I have button to run the query.
The query is titled employee list and should display the job title and corresponding job code based on the users entry to the form. I have been working on this for days and can not figure out what I am doing wrong- I am sure its quite simple but I am getting very frustrated. Any help would be greatly appreciated.
Thank you