Add records to a subform via a query

[topgeek]

I am trying to add a single record to the subform of fifty records in amin form.

i.e. I have employee names and departments on the main form and associated with each employee is one or more courses in the sub-form. I need to add a single course name and status field for every main record. i.e. all employees will be taking this course.

I cannot work out how to do this from a query. I could go through the database and add each individual record from the databse front-end but surely I must be able to use a query?

 

[PHV]

Take a look at Append query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244