Syntax in Query

[Chip]

Hey Everyone,

I have a multi-value field in Access 2007 and I want to use an UPDATE
query to change a field ina related. The tables in question are
tblClasses and tblExaminations.

In tblClasses, there is a field name Examassignment, which is bound to
the primary key of tblExaminations. Mutliple classes can attend the
same exam event and so this field is my Multivalue field. What I'd
like to do is program this fields AfterUpdate property to update the
tblExam with that classes ID.

Ive read the Microsoft article on the matter and it makes sense. The
SQL statement is

INSERT INTO Issues ( AssignedTo.[Value] )
VALUES (6)
WHERE ID = 10;

I've put this code into my forms AfterUpdate event, I have changed it
to read

INSERT INTO "Examination Schedule (AssignedClass.[Value])
VALUES (AssignedClass.[Value]
WHERE ID = frmCourses.ID

But so far no luck. What is the correct way to a) draw the records ID
field so we can equte the WHERE statement and b) pull the the class
value to insert it into the VALUES line.

I know this is a new feature for access 2007, but does anyone know of
any articles where this is illustrated a little better than Microsofts
article?

Chip