On Wed, 27 Dec 2006 16:21:01 -0800, NC_Sue
wrote:

My Subform is based on tblPatientProtocolActivity; I have a Combo
Box control on the subform, bound to Protocol_ID, and based on
tblProtocol; the Protocol_ID is the bound column of the combo
box... I just checked all of these things and they are true statements.


There is something we're not communicating!

Open your Relationships window and View All.

The only relationships you've mentioned are from tblProtocol to
tblPatientProtocolActivity, by Protocol_ID; and from tblPatients to
tblPatientProtocolActivity, by Patient_ID. Is that correct? Do you
have any relationships from the Primary Key of
tblPatientProtocolActivity to any other table (based on what you've
said, you shouldn't)?

John W. Vinson[MVP]