Update Query?

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

Not sure if this is the right place to put this so here it
goes. I have a table named tblEmployees that essentially
lists all my employees. I want the ability to Enter new
employees on my main form. Kind of like a command button
or textbox that sends that info to the table, but leaves
the other "stuff" in there. Now to do this I think I need
to create a query that adds this name to the list of
individuals I already have or some sort of update query.
I tried a lot of things, but nothings working. Any help
would be appreciated.

Frank
 
The form can write the data directly to the table, so why the need for the
query?
 
Since you mentioned other 'stuff', I assume that your tblEmployees is a list
(combo box) on a form or datasheet. If you are trying to add an employee
name that does not exist, you could add a 'No On List' property to the combo
box.

ed
 
Back
Top