Repeat record entry

[Guest]

Ok, I think ive done this all wrong, sorry if this answer is in the threads
but i couldnt find it so here goes...
I have a table of Vehicle Inspectors, lastname,firstname, qualifications,
etc The primary field in this table is Vehicle Inspector Code. When i open
a form based on this table to display a vehicle inspectors details, i have a
subform to allow me to enter a date and Training - this subform is from
another table called training . At the moment I can enter individual
training for one vehicle inspector at a time. The problem is, there is also
Training done as a whole for all the vehicle inspectors and not individually.
How can I enter the date and training for all vehicle inspectors once and
have it display on all their records? Wow this is confusing! but thanks
Deb

 

[Guest]

Create an Append query that joins your inspectors table and your training
table and inserts data based on controls on a form with the information you
want in the records and the data from the inspectors table to complete
training records. Once you have entered information in the form necessary to
complete the training records, run the query from a command button.

 

[jahoobob via AccessMonster.com]

I have a training db and I do the reverse. I have a form with the training
and I add the particpants via a subform (Continuous) where I enter the
participants via a combobox. That way you can "train" one or many.
It takes about the same time yours would for just one but speeds up the many
algebraically.
Once you get to the subform it usually is type in the first few letters of
the lastname, TAB, repeat. Sometimes when I get to a common name like Smith
I have to actually use the dropdown. My list of potential participants is
over 600 and this method works great.
Bob

 

[Guest]

Thanks the both of you, two very helpful suggestions, i appreciate your help
deb

 

[Guest]

Ok, Im still having problems! i still dont get how on your subform you can
choose all participants or inspectors when its a combo box and you select
one. I also tried an append query but I need more help or an exact 'recipe'