Update Query?

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
 
M

[MVP] S.Clark

The form can write the data directly to the table, so why the need for the
query?
 
E

Ed

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
 
Top