Newbie Question on Forms

[Cheryl]

I inherited a database that tracks employee training records. Each employee
is required to take certain classes based on his or her job title (i.e.
Manager, Software Lead, SQA, etc.). If an employee's title/job changes the
list of required classes also changes. The database is way out of date, with
new job titles being added, but old ones not being deleted, for individual
employees.

I have created two reports: one to list each employee and show the current
job titles listed for him and another to show each job title and all the
employees that currently have that job title. I have also created a
parameter query that, given an employee ID will bring up the employee's name
and current job titles.

Now I want to create a form so that we can easily edit an employee's job
titles. I have a form based on the parameter query above. The main form
contains the employee ID, last name, and first name. A subform contains the
job titles. For a single run of a single employee, I am able to add or
delete job titles. However, I would like to add a control (or some other
funtionality) so that when I am finished with one employee, I can either
enter another employee ID and edit his records or press a "Next" button and
get the "Enter employee ID" parameter request that precedes the opening of
the form.

I am still new at Access. I have tried a few things, but so far, nothing
has worked. I have gone through some on-line tutorials, but didn't find a
solution to this. I am using Access 2003 with SP2 on a Windows XP computer.

Thank you for any suggestions!

 

[Arvin Meyer [MVP]]

A button which simply requieries the form, should bring up the parameter
query. Something like (untested):

Sub cmdNext_Click()
Me.Requery
End Sub

 

[Cheryl]

Amazing! I never would have thought it would be that easy.

Thank you!