How do I put all information in subform....

[tracey75]

What i want is a subform of my form. I want it to list all of that employees problems not just the one that is selected on the form itself. I have 2 different querries for this but running off the same table. How do i make this work

 

[Tammy]

I have been using forms and subforms quite a bit lately and what I would do is add the subform control from your toolbar to your form and base the subform on the table (i.e. Problems Table) /or a seperate query without an joining to the table or query that your form itself is base on that way you will get all employee records not just those that match the key. I hope this makes some sense and helps a little.

 

[tracey75]

I have the subform based on a query which is based on a table. So what you are saying i dont quite understand can you explain a little more detailed. Iam new at this!!

 

[Carol]

Your subform should be linked to the main form by your EmployeeID field. Make the subform a continuous form with the properties set to Show All Records. Your subform should be based upon a query that contains all of the employees problems.
Good Luck

 

[tracey75]

Ok Carol,
I'm new at this could you explain it in exact detail where i need to go for each step.

This is what i have dont know if its right:
My subform is from the main form which i made a query from. I am actually confusing myself.

Thanks