Subform with Combo-box not working after linking with Main form...

[Guest]

I have a form with basic employee data; First Name, Last Name, Department,
Reports To, etc.

I want to add a sub-form that has a combo box with 30 Job Titles and
depending on the combo box selection, the sub-form would that auto fill Job
Description, Responsibilities, Qualifications, etc.

I have created two tables; Employee Data and Job Descriptions – both have an
auto-number ID field.
I have also created a Query that includes all the fields from both tables.

The sub-form works as a form by itself, however, once I add it to the
Employee Data form as a sub-form and Link the Master/Child fields using ID,
the 30 job records , turns into 1 record and the text boxes to display the
records are blank.
Please help.
Thanks!

 

[Guest]

It sound as if you have joined the 2 tables in the query using a left inner
join. This will mean that you will see only result where the 2nd (id field)
match those from the 1st (id field) this is why you are only seeing one
result.

Open the query in design view and right click on the line between the
tables. There will be 3 choices. Choose which ever one suits you best and
save the results.. Have a look at the results and if they aren't what you're
after changed the join again until you're happy.

Next do a search on help (press F1) and look Types of query joins for more
infomation

Hope this helps