Switchboard

[DDR]

I have a database of employees and their performance data. There are 248
employees between 18 managers. Currently when actions in the database need to
be done I have an employee lookup form that will run a query and populate
that information in a new form such as employee status update. What I want to
do is setup up a Switchboard that does that in reverse, meaning that when a
manager logins to access it will populate his/her team. This link will bring
up and populate the employees information into a form that will show all
performance data/HR data for the employee. Does anyone know the best way to
get started, or is this something that cant be done in access. I have seen
similar things on WebPages like MSN where it populates all the stock symbols
that you look at and the by clicking will give you that quote. I am looking
to do something similar.

Thanks in advance!!!

 

[Bob Miller]

You could add a lookup combobox to the form. When adding the combobox,
select the third choice on the first wizard screen, "Find a record on
my form based..." and use the table/query on which the form is based as
the source of the combobox. A person can begin typing a name in the
combo and after about thre letters get the name if it is unique. If
there are names that aren't unique, like 3 Smiths, all will be there
from which to select when you use the drop down.