Link Subform to form

[Gary J. Monreal]

Hello,
I currently have a form listing officers by name and rank. I created a
subform so that I can list all the training that the officer recieves (i.e.
radar, SWAT, Accident Invest.) but when I change to input another officer's
name the information for the first officer remains in the subform. How do I
get the subform to link directly to each individual officer?
Thank your for your time and help!
Gary

 

[John Vinson]

Hello,
I currently have a form listing officers by name and rank. I created a
subform so that I can list all the training that the officer recieves (i.e.
radar, SWAT, Accident Invest.) but when I change to input another officer's
name the information for the first officer remains in the subform. How do I
get the subform to link directly to each individual officer?
Thank your for your time and help!
Gary

What is the structure of your underlying tables, and how are they
related? Typically one would have a table of Officers with a unique
OfficerID; a table of training courses available; and a third table
with one record for each training session attended by each officer. If
this is your structure, then you should be able to get the desired
result by basing the Subform on this third table, using the OfficerID
as the Master/Child Link Field property of the Subform.

If, however, you're just overtyping the officer's name on the mainform
then you are actually *changing the contents of that officer's
record*, not moving to a different officer. What steps do you take to
"change to input another officer's name"?