Automatically fill data into subform

[Guest]

Hi Need some help.

I've got a database that I'm designing for work that will
list the courses staff will take and when they will take
them.

I have a staff table listing all staff details.
I have a course details table listing all courses
available.

I designed a form that will take this info and save it to
a course input table.

What I want to do and know how to do it is have a subform
embeded in the main form and when I select a staff member
and say the word beginner course from the main form that
the staff name and the word intermediate, advanced and
refresher course will automatically fill in to the subform.

Any help please.

Graham.

 

[Mike Painter]

Hi Need some help.

I've got a database that I'm designing for work that will
list the courses staff will take and when they will take
them.

I have a staff table listing all staff details.
I have a course details table listing all courses
available.

I designed a form that will take this info and save it to
a course input table.

What I want to do and know how to do it is have a subform
embeded in the main form and when I select a staff member
and say the word beginner course from the main form that
the staff name and the word intermediate, advanced and
refresher course will automatically fill in to the subform.

Any help please.

I usually do it with an append query. If for example you just had the word
classes you would have a table with ClassID, description,... and three
records in it.
You would append your Classes table with those records and your StudentID
would be Forms!YourFormName!YourStudentID.
You would probably need a Forms!YourFormName!YourMasterCourseName