show in one form but doesnt show in the other

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
 
T

Tim Ferguson

I have a form with
mutlipe tables connecting to it.

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.

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

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

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
 

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

Top