Combo Box Help

[Steve]

I have a form with 3 simple combo boxes. First Name, Last Name and Supervisor.
The form is supposed to allow the user to change the Supervisor of the
employee. What I'd like to happen is when I select a Last Name, the First
Name box will only display those first names that have the selected last name
from the table. All of these fields are on a table as well as a unique ID. I
use MS Access 2003. Thanks

 

[Jeff Boyce]

Steve

An alternate approach would be to create a query that concatenates
[LastName] & ", " & [FirstName], and includes the PersonID as the first
field.

Then you only need a Person combobox and a Supervisor combobox.

By the way, if Supervisors are considered human in your organization, you
could use the SAME query to fill each combobox!

Regards

Jeff Boyce
Microsoft Office/Access MVP