Form/Subform or Table Problem

[Anke via AccessMonster.com]

I have a database that was created by somebody else as a Access 2000 format.
We have upgraded to Access 2007 over the summer and had little problems. As
we wanted to get more information, I added a field to one of the tables, and
I think that's when a problem started.

This is a customer database with many different tables, forms and reports and
I am concerned about 2 tables. One table 'Customer Information' stores all
customer names and addresses. The second table ' Contact' stores all contact
names, phone numbers and e-mail addresses. Because one customer may have
several contact names, both tables are linked through a common field CUSTID#

My form Customer Information includes a subform with the 'contact' table. We
used to be able to open the record or form for a specific customer, wether
this customer had a contact name associated or not. We now added another
field to the table ' Inactive' Customer' as a Yes/No field, as we didn't want
to delete the contact's record completely and each contact name was
originally set up with an autonumber. To delete a contact name/autonumber
would just create more problems.
Since the new field was added, the form will not display any records or
customer information, unless a contact name is linked with this customer. I
manually linked all missing customers with generic contacts for now, however,
I know the problem is still there and I don not know how to fix this. Any
ideas on what I am doing wrong?

Thanks for any suggestions.

 

[ruralguy via AccessMonster.com]

It sounds like the RecordSource of the MainForm is a Query with an Inner Join.
A MainForm/SubForm arrangement would only require a query of the Customer
table as the RecordSource of the MainForm and a query of the Contacts table
as the RecordSource of the SubForm with the CUSTID# as the SubFormControl's
LinkChild/MasterFields properties.