Can't enter on form/query

  • Thread starter Thread starter Annie
  • Start date Start date
A

Annie

Hi. I am trying to flip what I've been doing. Rather than
signing people up for course, I'm trying to go to the
people form and use a combo box to choose the course to
assign them to. I have a composite primary key that may
be causing strife. Both my query and subform shows what
I'd expect. However, the >* is greyed out, so that I can't
select courses to assign.

tblCourseSponsors (CPK)
CourseID
OrganizationID

tblOrganization
OrganizationID (PK)

tblCourse
CourseID (PK)

tblEvent
EventID (PK)
CourseID
PeopleID

Also:
tblPeople
People ID (PK)

If I leave out tblCourseSponsors and tblOrganization, all
is well. But I need Organization name (tblOrganization)
and I can't there without tblCourseSponsors. I've tried
to combine two different queries but nothing has worked.
What am I missing? Thanks Annie
 
Annie,

I assume you are using a subform for the enrolments? I supppose this
subform is based on a query which primarily contains the tblEvents
table? My guess is that the query which is the Record Source of the
subform is a non-updateable query. There are a number of factors that
determine whether a query is updateable or not. There is good
information on this topic in Access Help. Otherwise, you could try
posting the SQL view of the query here, and someone may be able to advise.
 
Thanks for the information. I would never have thought of
this problem as a update query issue, but knowing that
makes it much easier to search "help"! Thanks, Annie
 
Annie,

If you are looking in Help, there is a big difference between an Update
Query, and an Updateable Query (or it might be spelled "updatable").
 
Back
Top