Need to filter subform using one list box

[Zach Hokett]

Hello,

I have a subform which shows a list of teachers and what classes they teach. The subform is based on a query.

Currently I am able to choose which teacher I want to view by selecting the teacher name from a list box in the main form. By linking the parent and child field [Name] I am able to see individuals.

I'm not sure if it is because of this method, but periodically random unwanted records are added to the different teachers and I cannot figure out what the problem is.

Is there another less complicated way to filter a subform based on a query using a list box?

 

[NetworkTrade]

random unwanted records; generally this is caused by a new record being
created where the user is unaware that it is occurring.... they may be
tabbing into the record triggering perhaps a default value being generated
(i.e. date)...just one guess........but some way a record is occasionally
being created...

investigate all the user's potential moves and see which is triggering the
record to exist.....you should be able to prevent or undo that record
creation one way or another....