Can't Add Record in SubForm

R

Rob

Hello,

i have a form which lists a person's demographic information. This form has
a subform which lists the events a person went to. I would like to be able
to add a committee if necessary, but it is not letting me. The source of the
form is:

SELECT Sponsorship.Event_ID, Mem_And_NonMem_Spsrs.Mem_ID, Events.Event FROM
(Sponsorship INNER JOIN Mem_And_NonMem_Spsrs ON
Sponsorship.Mem_ID=Mem_And_NonMem_Spsrs.Mem_ID) INNER JOIN Events ON
Sponsorship.Event_ID=Events.Event_ID;

The Fields:
Mem_ID = person's ID number
Event_ID = event id number
Event= event name

The tables:
Sponsorship - contains event_id and mem_id
Mem_And_NonMem_Spsrs - contains members demographic information
Events - contains The Event name and Event_ID

For whatever reason, i can't add a new record. Any suggestions/help??

Thanks in advance,
Rob
 
Top