create a drop down list that changes with each new entry

[smpyeroy]

I am using Access 2003 and want a list box under the heading Division for a
personnel database. Each employee will be either in Painting, Environmental,
Access services etc. When I create a box now with the different headings
stored when I change the division from the list box it remains static
throughout meaning all employees are painters or whatever is selected.

 

[Sharkbyte]

You will need to base your record source query, in your Name combo box, to
include the type of employee (painter, environmental, etc.) as a where clause.

Sharkbyte