use lookup to check for existing entries

[lynn atkinson]

I have a form which is filled in for all applicants
applying for a job. The applicants may be new to the
organisation, in which case a new record is created in
the 'worker details' table, creating a new employee ID.
This employee ID is entered in to the application form and
the data is displayed in the application form.
However, The applicant may already be employed in the
organisation and therefore their details already exist in
the 'workers details' table and with input of their
employee ID number, the details are displayed in the
application form.
What I would like to do is find a way of checking whether
a person already exists in the system and if they do,
automatically input their employee ID in to the
application form and therefore their details will be
displayed.
Any suggestions?

 

[Jeff Boyce]

Lynn

If you were speaking with an applicant, how would you determine if s/he were
"already employed in the organisation"? Would you ask their name? What if
your organisation employed two "John Smiths"? Would you ask their
EmployeeID#?

Whatever you'd ask, that is already available in your database, you can use
as the source in a combo box, allowing you to select an individual (and load
his/her existing data).

Good luck

Jeff Boyce
<Access MVP>