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

Populate main form from subform record 0
Unremovable horizontal scroll bar on subform 1
First Subform record gets modified when closing form 3
Dynamic Naming of Form Button 3
DLookup in Continuous form 0
Request Form - Alert Team Member 0
Trouble associating parent form record to subform's record 1
VBA Syntax for subform record source change 6

Top