Using a Form to Update a Table- Please Assist

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I have an employee table that continously needs to be
updated with new employees. Instead of going into the
table itself and adding the employee so that it appears in
a drop down menu; i want to add a form (we'll call it "Add
New Rep") that the user can access and add the new
employee and have that form automatically update the table
thus updating that drop down menu.. hope that makes
since.. Can anyone assist, any feedback is greatly
apprecaited...

Ray
 
Dear Ray.

Thankfully a nice easy one to answer. Design a new form
and base it on the same table that the drop-down reads
from. You can then use a button on any other form to open
the "NewRep" form. If you want to have the form with the
drop form still active in the background (For example if
the user looks at the dropdown and cant find the rep's
name, so wants to add it to the list there and then.)you
will have to requery the drop-down when you close
the "NewReps" form.

Hope this helps

Paul
 
Back
Top