show in one form but doesnt show in the other

  • Thread starter Thread starter mega
  • Start date Start date
M

mega

Thank you for reading my message. I have a form with
mutlipe tables connecting to it. One table is contacts and
one table is companies. The form is able to show both
companies and contacts at the same time. My problem is
the contacts are not shown on the form, but can be seen in
the contact table. This problem does not occur for all
contacts. Does anybody have a clue why is this occurring
 
I have a form with
mutlipe tables connecting to it.
Click to expand...

No you don't. A form is connected to a single query -- are you talking
about a query that joins several tables?
One table is contacts and
one table is companies. The form is able to show both
companies and contacts at the same time.
Click to expand...

Okay, probably a join then.
My problem is
the contacts are not shown on the form, but can be seen in
the contact table.
Click to expand...

Hang on, you just said the form is able to show both..? And what,
precisely, are you referring to be "contact table" -- a subform on the
companies form, or actually going to the database window to open the
contacts table?
This problem does not occur for all
contacts. Does anybody have a clue why is this occurring
Click to expand...

No. I suggest you post some more information, specifically:-

The structure of the tables and _exactly_ what relationship you
created between them;

The RecordSource of the table; and

If there is a subform, its RecordSource and the LinkFields.

B Wishes

Tim F
 
Back
Top