Action Queries (1 Viewer)

[Treason]

I am just beginning to understand the power of MS Access as an application. Yet I am having many problems finding how to use action queries correctly.

I have created a query that will display a list that i would like to then use as a listbox in an action query. For example, I would enter an Employee ID, and get a list of that employee's current jobs, then i would like to use the action query to select a new job from a listbox to replace any given job.

I know this is possible. I guess I want to append fields in a table using a listbox. Again I am new to Access and any help is greatly appreciated.

 

[Pat Hartman]

Wouldn't this be easier to do with a form for the employee and a subform for his jobs? You could add an unbound combo to the main form to be used for looking up a particular employee's information.