Combo Box

[Keith]

I have created a table with the fields I want...
(employees names). I want to have the combo box show the
names and then when I pick the right one, move to the
next area. Then when I click "Add next record", it will
clear and give me a blank record to fill in.

I can get the combo to show, but when I pick a name....it
stays displayed.

Thanks in advanced!

 

[John Vinson]

I have created a table with the fields I want...
(employees names). I want to have the combo box show the
names and then when I pick the right one, move to the
next area. Then when I click "Add next record", it will
clear and give me a blank record to fill in.

I can get the combo to show, but when I pick a name....it
stays displayed.

Thanks in advanced!

If you're doing this in a table datasheet... DON'T.

Table datasheets are of very limited utility. Create a Form instead.
You can put a Combo Box on a Form to navigate to a desired record,
*or* to update a new or an existing record to a selected name (a
single combo cannot fulfill both these roles though).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps