Subform to Main Form Record Problem

A

Adriana

I have a main task table with a subform that has task elements and another
subform within the task element subform to record multiple employees. The
form is showing the same top level record two to three times depending on how
many subtasks I create. How do I get the form to only show the main top
level record once if I have a few records within the subform? My form is
based on a query by the way.
 
J

Joan Wild

It's likely the query that is causing the problem. An INNER JOIN to the
task element table, maybe? Why don't you post your SQL statement that the
mainform is based on. Or why not just use the 'task' table as its
recordsource?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Main form/Subform Navigation 0
First Subform record gets modified when closing form 3
Update subform with combobox change on main form 1
Unremovable horizontal scroll bar on subform 1
Main Form and two Subforms 2
subform within subform On Main for Child master link question 2
Set focus in a specific record within a subform 1
Trouble associating parent form record to subform's record 1

Top