HELP:

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

ACCESS 2000

I have a database that contains 70+ employees and I am looking to structure
my forms in a manner that would show the list of employees at the top of the
screen, and if you click on the name or button next to their name, it would
open their records in a sub-form.

I would like to avoid having scrool back and forth through each employee.

Does anyone have any ideas that would help.
 
Move your vaildation code to the Before Update event of the form. It has a
cancel function.
 
Sorry, Tim. This is weird. Unless I did something I was not aware of, this
is not the post I answered. Don't know how that got so fouled up.
 
You can place a combo box (that contains all the employees name or ID) at the
top of the form. Then use the afterupdate event of the combo to filter the
records of the subform to bring up the record of the employee you pick from
the combo.
Placing textboxes or labels containing the id of each employee at the top of
the form will do the same trick; you would then use the click or double-click
event to filter the subform. However, you would have to put so many controls
in place. Alternatively, one unbound textbox would also work but it would not
be able to eliminate typo-errors.
 
Back
Top