MS Access, adding a detail to multiple contatcs at once?

[Destination]

Building a training database
I have records for all staff, and task lists associated with it
Is it possible to generate a form that lets me assign a value (ie a name of a course and the date in which is was completed) to multiple people at once?

So I have my staff list and within their contact details I have a separate sheet for training, is it possible to design a form which would allow a drop down box, or multiple selection box, which would update lots of different contacts at once, with information on training provided, so one doesn't have to enter every course for every member of staff at one time.

 

[Destination]

I think I have managed to create a table capable of accepting the data I wish to add.

My issue now is getting the appropriate information to display within a new tab of a 'contact details' form request, when the contact form is opened.

 

[Destination]

Of my two main tables, contacts and training
Contacts record peoples general info
Training is more specific, and has fields for when, duration, trainer, and who attended.
The who attended field has been set to allow multiple values, so everyone who attended a session can be added.

What I am trying to do is general a query or report or subform that enables me to find all training sessions attended by a person. I can't find a way to query the 'who's attended' field. I can output the values from the who's attended field if I query any other field in that table, but I can't seem to query a field with multiple values looking for any name within it.

Anyone help me on process to achieve what I need?
Any attempt to add a second page which links the

 

[dazzerd]

Hhmm seems to me like you are binding your controls to queries or direct to tables which is not best practice in most cases/.

Anyway it is quite hard to figure out what you want, possibly best to post a copy of your sql and your table fields.

If you are trying to retrieve data best on best fit then you need to use like in your query. In other words if your field contains:

John Smith
Amy Smith
Joe Bloggs

And you want to return results for everybody called Smith, then use something like

Select FIELDNAME from myTable where fieldName Like "*" & "Smith".

If you need to take values from your forms then you want to look at parsing that value to a parameter.