Autofill Options

I am developing a database to track training for employees. I would like to
be able to type in a first and/or last name and/or an employee number and
auto fill what I don't enter. My managers will be using this database and in
order for it to be accurate and complete I need first/last name and employee
number. I can't figure out how to get an autofill option to work.

TC

It isn't clear where you want this to happen...

If you are using MS Access, the appropriate place would be in a form (rather
than directly in a table).

In a form, there really wouldn't be a need to auto-fill values you already
have stored (but then, perhaps what you mean by autofill doesn't involve
re-saving redundant values).

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"TC" wrote in message
...
I am developing a database to track training for employees. I would like
to
be able to type in a first and/or last name and/or an employee number and
auto fill what I don't enter. My managers will be using this database and
in
order for it to be accurate and complete I need first/last name and
employee
number. I can't figure out how to get an autofill option to work.

TC