At the moment, the tables are pretty separate - the only Contact/Event links
are the organiser and, where needed, a Billing Contact - the other Contacts
are our mailing list... This may give a clue as to what another table needs
to be? My aom was to have one form for everything for myself and receptionist
and then various forms for details that others can access... this may be too
ambitious?!

Here, anyway, are the Form's RecordSource properties...

SELECT Events.*, Contacts.Title AS Title_Contacts, Contacts.[First Name] AS
[First Name_Contacts], Contacts.[Last Name] AS [Last Name_Contacts],
Contacts.Address1, Contacts.[Town/City], Contacts.County, Contacts.[Postal
Code], Contacts.Billingaddress1, Contacts.[BillingTown/City],
Contacts.BillingCounty, Contacts.Billingpostcode, Contacts.Billingtitle,
Contacts.BillingFirstName, Contacts.BillingLastName, Contacts.[Business
Phone], Contacts.[E-mail Address], Contacts.[Mobile Phone] FROM Contacts
INNER JOIN Events ON Contacts.[ContactID]=Events.[Contact ID];

The Contact table's primary key is ContactID, the Events simply ID. The
relationship is Contact: ContactID Events: Contact ID.

Am away for a few days now (cool the brain down a bit!) but will check out
responses when I get back.

Many thanks again.

"John W. Vinson" wrote:

On Thu, 1 Apr 2010 09:56:05 -0700, Kathryn
wrote:

I have two related tables - Events and Contacts. I have created a form which
populates both but the only records it will show are the most recent ones
typed into the form itself - it does not pull in the existing information
from the tables. I have checked the Properties and Data Entry is set to No
and Allow Edit, etc are all Yes.

(Interestingly, it also populates the form "Events List" - from the Access
2007 Events Template - which I would like to be able to use but which again
will populate the Events table but won't update from it).

What do I need to do to get a mutual dialogue going between the tables and
the forms? Or is it a case of re-inputing everything through the form(s)?

I hope that makes sense. If I need to use code, please could it be explained
very simply!

Many thanks

What is the Recordsource property of the form? Open it in design view and view
its Properties. Normally the recordsource will be a query.

If each Contact may be involved in multiple Events and each Event may involve
multiple Contacts, you need another table! How are these two tables related
currently? What is each table's Primary Key?

--

John W. Vinson [MVP]
.